Postgres Pro
Downloads
Home   >   mailing lists

Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication - Mailing list pgsql-general

From Ron Johnson
Subject Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication
Date
Msg-id CANzqJaCbagpPpt6mhjA1UDCJ6xpHV-SWim6vOCWKcZjRjuSm=g@mail.gmail.com
Whole thread Raw
In response to Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication  (Christophe Pettus <xof@thebuild.com>)
Responses Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication
List pgsql-general
Tree view
On Sun, Nov 24, 2024 at 2:55 PM Christophe Pettus <xof@thebuild.com> wrote:
> On Nov 24, 2024, at 09:15, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
>
> Doesn't the existence of a replication slot force PG to retain WAL files when replication is broken?

It does.  I don't recall if the OP said that they were using a persistent replication slot or not; it's not as common with binary replication as with logical replication.

Really? I wonder why people fight with configuring max_wal_size and wal_keep_size, when replication slots do all the work for you.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication
Next
From: Adrian Klaver
Date:
Subject: Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication