Re: setting up streaming replication - Mailing list pgsql-general

From Christophe Pettus
Subject Re: setting up streaming replication
Date
Msg-id 587165B2-19D4-4C11-90AB-85DED9CCC70B@thebuild.com
Whole thread Raw
In response to Re: setting up streaming replication  (Brad White <b55white@gmail.com>)
List pgsql-general

> On Oct 24, 2023, at 11:31, Brad White <b55white@gmail.com> wrote:
> Are you saying that once I get streaming replication set up, it quits working when I reboot the servers once a week?

Not unless the downtime is sufficiently long that the replica can't find the WAL information it needs.  You can avoid
thiswith PostgreSQL settings, but you might also consider keeping a WAL archive in a cloud storage system like S3 (it
canbe combined with backups, using a tool like pgBackRest). 


pgsql-general by date:

Previous
From: Brad White
Date:
Subject: Re: setting up streaming replication
Next
From: Ron
Date:
Subject: Re: setting up streaming replication