On Sun, Nov 24, 2024 at 12:06 PM Christophe Pettus <x...@thebuild.com> wrote:
> > On Nov 24, 2024, at 09:03, Subhash Udata <subhashud...@gmail.com> wrote: > > When we shut down the standby, upgrade it, and then start it back up, > will the replication automatically resume from the primary to the standby? > > Assuming that the standby has access to any WAL generated during the > shutdown (either still in the primary's WAL directory, or via an archive > using archive_command), yes. If you are not using a WAL archive using > archive_command, you will want to make sure your wal_keep_size parameter is > set high enough that required WAL segments aren't recycled during the > standby's downtime. Doesn't the existence of a replication slot force PG to retain WAL files when replication is broken? -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
