Re: Long running query causing XID limit breach

Hello Laurenz, Thank you so much.This information was really helpful for us understanding the working of these parameters. One follow up question i have , as we are setting one of the standby/replica with value idle_in_transaction_session_timeout=-1 which can cause the WAL's to be heavily backlog

Re: Purpose of pg_dump tar archive format?

On Tue, Jun 4, 2024 at 3:47 PM Gavin Roy wrote: > > On Tue, Jun 4, 2024 at 3:15 PM Ron Johnson > wrote: > >> >> But why tar instead of custom? That was part of my original question. >> > > I've found it pretty useful for programmatically accessing data in a dump > for large databases outside of

Re: Questions on logical replication

On 6/4/24 15:55, Koen De Groote wrote: I recently read the entire documentation on logical replication, but am left with a question on the buildup of WAL On this page: https://www.postgresql.org/docs/current/logical-replication-subscription.html#LOGICAL-REPLICATION-SUBSCRIPTION-SLOT

Re: Questions on logical replication

Reading this: https://www.postgresql.org/docs/current/warm-standby.html#STREAMING-REPLICATION-SLOTS " Replication slots provide an automated way to ensure that the primary does not remove WAL segments until they have been received by all standbys, and that the primary does not remove rows which co

Questions on logical replication

I recently read the entire documentation on logical replication, but am left with a question on the buildup of WAL On this page: https://www.postgresql.org/docs/current/logical-replication-subscription.html#LOGICAL-REPLICATION-SUBSCRIPTION-SLOT It is written: " When dropping a subscription, the r

Re: Purpose of pg_dump tar archive format?

On Tue, 4 Jun 2024 at 20:47, Gavin Roy wrote: > > On Tue, Jun 4, 2024 at 3:15 PM Ron Johnson > wrote: > >> >> But why tar instead of custom? That was part of my original question. >> > > I've found it pretty useful for programmatically accessing data in a dump > for large databases outside of th

Re: Purpose of pg_dump tar archive format?

On Tue, Jun 4, 2024 at 3:15 PM Ron Johnson wrote: > > But why tar instead of custom? That was part of my original question. > I've found it pretty useful for programmatically accessing data in a dump for large databases outside of the normal pg_dump/pg_restore workflow. You don't have to seek th

Re: Purpose of pg_dump tar archive format?

On 6/4/24 13:15, Ron Johnson wrote: On Tue, Jun 4, 2024 at 2:55 PM Rob Sargent wrote: On 6/4/24 11:40, Shaheed Haque wrote: > > We use it. I bet lots of others do too. > > Of course.  There are lots of small, real, useful databases in the wild. But why tar inst

Re: Purpose of pg_dump tar archive format?

On Tue, Jun 4, 2024 at 2:55 PM Rob Sargent wrote: > > > On 6/4/24 11:40, Shaheed Haque wrote: > > > > We use it. I bet lots of others do too. > > > > > > Of course. There are lots of small, real, useful databases in the wild. > But why tar instead of custom? That was part of my original questio

Re: Purpose of pg_dump tar archive format?

On 6/4/24 11:40, Shaheed Haque wrote: We use it. I bet lots of others do too. Of course.  There are lots of small, real, useful databases in the wild.

Re: Bugs details.

On 2024-06-04 19:55 +0200, Muhammad Salahuddin Manzoor wrote: > I need to get detailed information about PG bugs and fixes. > > I can get the information about new features and Fixes in the release > document but I find only descriptions for each fix. I need detailed > information about these fixe

Bugs details.

Greetings, I need to get detailed information about PG bugs and fixes. I can get the information about new features and Fixes in the release document but I find only descriptions for each fix. I need detailed information about these fixes. How can I get details about the fix. Suppose the release

Re: Purpose of pg_dump tar archive format?

We use it. I bet lots of others do too. On Tue, 4 Jun 2024, 18:06 Adrian Klaver, wrote: > Reply to list also. > Ccing list > > On 6/4/24 10:03 AM, Ron Johnson wrote: > > > > > If you don't need the tar format then don't use it. > > > > > > That's neither the purpose nor the point of my quest

Re: Purpose of pg_dump tar archive format?

Reply to list also. Ccing list On 6/4/24 10:03 AM, Ron Johnson wrote: If you don't need the tar format then don't use it. That's neither the purpose nor the point of my question. I think that a note in the docs mentioning that it's obsolete would be helpful for new users who recognize

Re: Purpose of pg_dump tar archive format?

Adrian Klaver writes: > If you don't need the tar format then don't use it. Indeed. FTR, I think the original motivation for tar format was to have a "standard" structured output format that could be manipulated with tools other than pg_restore. Years later, we added the directory format which

Re: Purpose of pg_dump tar archive format?

On 6/4/24 08:25, Ron Johnson wrote: On Tue, Jun 4, 2024 at 10:43 AM Adrian Klaver > wrote: On 6/4/24 05:13, Ron Johnson wrote: > It doesn't support compression nor restore reordering like the custom > format, so I'm having trouble seeing why it

Re: Purpose of pg_dump tar archive format?

On Tue, Jun 4, 2024 at 10:43 AM Adrian Klaver wrote: > On 6/4/24 05:13, Ron Johnson wrote: > > It doesn't support compression nor restore reordering like the custom > > format, so I'm having trouble seeing why it still exists (at least > > without a doc warning that it's obsolete). > > pg_dump -d

Re: Purpose of pg_dump tar archive format?

On 6/4/24 05:13, Ron Johnson wrote: It doesn't support compression nor restore reordering like the custom format, so I'm having trouble seeing why it still exists (at least without a doc warning that it's obsolete). pg_dump -d test -U postgres -Ft | gzip --stdout > test.tgz -- Adrian Klaver

Re: Purpose of pg_dump tar archive format?

On 2024-06-04 14:13 +0200, Ron Johnson wrote: > It doesn't support compression nor restore reordering like the custom > format, so I'm having trouble seeing why it still exists (at least without > a doc warning that it's obsolete). Maybe because of this: > * The tar format also includes a 're

Purpose of pg_dump tar archive format?

It doesn't support compression nor restore reordering like the custom format, so I'm having trouble seeing why it still exists (at least without a doc warning that it's obsolete).