Re: Can a long running procedure detect when smart shutdown is pending?

Thanks everyone. A more direct way to check via a sql function would be better but I suppose the dblink extension method will work. Thanks again, Dennis On Sat, Jul 6, 2024 at 9:38 AM Tom Lane wrote: > Laurenz Albe writes: > > On Fri, 2024-07-05 at 14:12 -0400, Dennis White wrote

Re: Can a long running procedure detect when smart shutdown is pending?

Thanks for responding. This will be a stored procedure written in plpgsql that's kicked off by pg_cron. I wasn't sure a normal smart shutdown would stop it. Thanks On Fri, Jul 5, 2024 at 4:57 PM Achilleas Mantzios < a.mantz...@cloud.gatewaynet.com> wrote: > Στις 5/7/24 21:1

Can a long running procedure detect when smart shutdown is pending?

bvious but is there a function to call or a table that could be checked after a commit within the procedure to determine a shutdown is pending? Thanks, Dennis

Re: How to do faster DML

I'm surprised no one has mentioned perhaps it's a good idea to partition this table while adding the pk. By your own statements the table is difficult to work with as is. Without partitioning the table, row inserts would need to walk the pk index and could be a factor. If this is static table then

Version 16.x search_path behavior change?

G(), JSON_OBJECT(), and JSON_OBJECTAGG() are part of the SQL standard. """ but I am not sure what this means in this case, as pg_catalog.json_object(..) also existed earlier, where the above search_path selectivity used to work. Is this intentional? If so, is there a recommendation as to how to work around this? Thanks for any suggestions, Dennis

Re: GIST combo index condition chosen for users queries is different from table owner's query

deployment. I will research the leakproof issue more and see what options we may have in dealing with this problem. Perhaps sometime in the future RLS won't break such queries but I understand that is probably not an easy task. Thanks for replying and helping me on my way. Dennis On Mon, Sep 19, 20

GIST combo index condition chosen for users queries is different from table owner's query

My project is using PostgreSQL 12.9 and has a table that gets millions of positions of ships every day. It is partitioned by tier (the importance of position) and sub-partitioned by time. We also use RLS to restrict access to rows in the table. Our problem is the query planner will not let user qu

Patroni pkg_resources.DistributionNotFound

Hi, I installed PostgreSQL cluster using Patroni and HAProxy on CentOS7. OS: centos 7 DB:postgreSQL 12 patroni : patroni-1.6.5-1 But when the patroni started that error occured. Are there any suggestion ? Regards Dennis [root@Centos7-04 ~]# sudo systemctl

[no subject]

Hi, Can I add custom sqls for regression tests (pg_regress) ? If it can be added how? Dennis

Re: check scripts after database code change

Thanks Ron; this is exactly what i was looking for. I would like to know if there are different things like this Dennis On Fri, Nov 19, 2021 at 11:07 AM Ron wrote: > There's a regression test suite. > https://www.postgresql.org/docs/current/regress.html > > On 11/19/21 2:01

Re: check scripts after database code change

swer more sophisticated then: maybe? After I make changes to the code to customize the database , I want to find a check mechanism to detect the negative effects of my changes. On Thu, Nov 18, 2021 at 7:07 PM Adrian Klaver wrote: > On 11/18/21 06:45, Dennis wrote: > > Hi, > > > &

check scripts after database code change

Hi, Are there any scripts that we can check after the changes we made in the database code? In summary, are there any automatic post-development scripts before they come to the beta stage? Dennis

RSYNC YUM Mirror for pg14 not available yet

ZYPP Repository - SRPMS pgrpmzypp-12PostgreSQL 12 ZYPP Repository pgsrpmzypp-12 PostgreSQL 12 ZYPP Repository - SRPMS pgrpmzypp-13PostgreSQL 13 ZYPP Repository pgsrpmzypp-13 PostgreSQL 13 ZYPP Repository - SRPMS pgcommonpgcommon Am I just too early for this? Thanks, Dennis

Re: Why would Postgres 11 suddenly ignore the recovery.conf file?

On 10/4/21 12:35, Dennis Jacobfeuerborn wrote: Hi, I just stopped and restarted a Postgres 11 docker container which so far has happily streamed the WAL from its primary but after the restart it now seems to completely ignore the recovery.conf file and just outputs this:  2021-10-04 10:14

Re: Why would Postgres 11 suddenly ignore the recovery.conf file?

That happened with Postgres 12 I think so it shouldn't affect this installation. On 10/4/21 12:40, Josef Šimánek wrote: Isn't this related to merge into postgresql.conf (https://www.postgresql.org/docs/current/recovery-config.html)? po 4. 10. 2021 v 12:35 odesílatel Dennis Jaco

Why would Postgres 11 suddenly ignore the recovery.conf file?

ect so I don't understand why Postgres seems to ignore it completely? Regards, Dennis

Re: "invalid record length" after restoring pg_basebackup

On 11/13/20 4:02 PM, Tom Lane wrote: > Dennis Jacobfeuerborn writes: >> All of this works fine and the logs report that the db reaches a >> consistent recovery state but as last entry it reports an "invalid >> record length": > > This looks quite normal to m

"invalid record length" after restoring pg_basebackup

d 24, got 0 It looks like the WAL in the backup is inconsistent at the end but I'd expect pg_basebackup to create a clean backup. Is this something I should expect or is this a problem with pg_basebackup? Regards, Dennis

Hash partitioning, what function is used to compute the hash?

Regarding hash partitioning, what is the function/algorithm that is used to compute the hash for the partition key? I need to write a query like “SELECT unknown_partition_hash_function(id) AS hash_value, COUNT(id) AS number_of_records FROM existing_table GROUP BY 1” Sent from Mail

How does pg_basebackup manage to create a snapshot of the filesystem?

is online. Am I misunderstanding something here or does pg_basebackup use some particular features of Postgres to accomplish this? Regards, Dennis

Load Peaks on Standby/Replication Server using Luks/dmcrypt

information you need to analyze this problem. Thanks, Dennis -- Dennis Schwan DBA Database Services 1&1 De-Mail GmbH | Brauerstraße 50 | 76135 Karlsruhe | Germany Phone: +49 721 91374-8738 E-Mail: dennis.sch...@1und1.de | Web: www.1und1.de Hauptsitz Montabaur, Amtsgericht Montabaur, HRB 2

Re: Code of Conduct plan

I have always been impressed with the core team's and posters' professionalism on this forum. I think the subject matter is vastly responsible for that, actuall and a natural filter for the people and the actual posts. But I also give this compliment  to all of you as individuals. Apparently we

Re: Insert UUID GEN 4 Value

Sent from Yahoo Mail on Android On Wed, May 30, 2018 at 8:25 PM, tango ward wrote: Hi, I would like to know how to properly use uuid_generate_v4 when inserting data into PostgreSQL table. When I run the command select * from pg_available_extensions;I can see this uuid-ossp  | aq