Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo

2024-12-04 Thread Gerhard Wiesinger
Hello, Any chance to get Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo quickly? Thnx. Ciao, Gerhard

Qsn on Setting replication using " set session_replication_role = "

2024-12-04 Thread Bharani SV-forum
  TeamNeed help on clarification on using" set  session_replication_role " Assume i am loggging intopsql and issue\o output.lstset session_replication_role=defaultupdate coming out of \psql command and verifying log fileand assume i come out of the psql session without doing set session_r

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

2024-12-04 Thread Bharani SV-forum
Team /Ron/Adrian Wann to reconfirmwe have an setup with  new server will be with  will be following the following suggestion On old VM [ existing server with OS "Amazon Linux release 2 (Karoo) " present in aws "us-east-1 region" and along with postgresql ver 13.16.2  - community edn ]  - "take

Re: Qsn on Setting replication using " set session_replication_role = "

2024-12-04 Thread David G. Johnston
On Wednesday, December 4, 2024, Bharani SV-forum wrote: > > > Team > Need help on clarification on using > " set session_replication_role " > > Assume i am loggging into > psql > and issue > \o output.lst > set session_replication_role=default > update > This seems like a bad idea. Why wou

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

2024-12-04 Thread Ron Johnson
On Wed, Dec 4, 2024 at 7:42 AM Bharani SV-forum wrote: > Team /Ron/Adrian > > Wann to reconfirm > we have an setup with > > new server will be with > > will be following the following suggestion > > *On old VM* [ existing server with OS "Amazon Linux release 2 (Karoo) " > present in aws "us-east-

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

2024-12-04 Thread Greg Sabino Mullane
On Wed, Dec 4, 2024 at 7:42 AM Bharani SV-forum wrote: > a) is the above said steps is correct with the given existing and proposed > setup > No. Here are some steps: * Install Postgres on the new VM However you get it, use the newest version you can. As of this writing, it is Postgres 17.2. Ve

Seamless age (xid) replacement

2024-12-04 Thread Ivan Shershnev
Hello! I need to use the 'age (xid)' function, but I have noticed that it is deprecated without a clear alternative. I know that xid is also kinda deprecated, so it makes sense not to use it. I can get xid8 from 'pg_current_xact_id()', which replaced 'txid_current()', but cannot use it right away

Clarification of behaviour when dropping partitions

2024-12-04 Thread Bolaji Wahab
Hi team, I have these two partitioned tables, with referential integrity. The tables are structured in such a way that we have 1 to 1 mapping between their partitions. This is achieved with a foreign key. ``` CREATE TABLE parent ( partition_date date NOT NULL, id uuid NOT NULL, extern

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

2024-12-04 Thread Adrian Klaver
On 12/4/24 04:42, Bharani SV-forum wrote: Team /Ron/Adrian Wann to reconfirm we have an setup with new server will be with will be following the following suggestion *On old VM* [ existing server with OS "Amazon Linux release 2 (Karoo) " present in aws "us-east-1 region" and along with postg

Re: Clarification of behaviour when dropping partitions

2024-12-04 Thread Laurenz Albe
On Wed, 2024-12-04 at 14:22 +0100, Bolaji Wahab wrote: > I have these two partitioned tables, with referential integrity. The tables > are structured in such a way that we have 1 to 1 mapping between their > partitions. This is achieved with a foreign key. > > CREATE TABLE parent ( >     partition

Re: Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo

2024-12-04 Thread Christiano Anderson
Hi, I'm Fedora package maintainer (but not of the pgpool package). It's the package maintainer's responsibility to update the package in different Fedora versions (40, 41 and Rawhide). There is already a ticket for this update: https://bugzilla.redhat.com/show_bug.cgi?id=2305049 Maybe it's

Re: Clarification of behaviour when dropping partitions

2024-12-04 Thread Laurenz Albe
On Wed, 2024-12-04 at 23:00 +0100, Bolaji Wahab wrote: > On Wed, Dec 4, 2024 at 6:20 PM Laurenz Albe wrote: > > On Wed, 2024-12-04 at 14:22 +0100, Bolaji Wahab wrote: > > > I have these two partitioned tables, with referential integrity. The > > > tables > > > are structured in such a way that we