On 10/24/23 13:31, Brad White wrote:
On Tue, Oct 24, 2023 at 8:56 AM Ron <ronljohnso...@gmail.com> wrote:On 10/24/23 08:14, b55white wrote:Is all that stuff with slots necessary since the backup will automatically create a temporary slot for replication?I want a permanent slot so that replication automatically resumes if the secondary must temporarily be taken down. -- Wait.Are you saying that once I get streaming replication set up, it quits working when I reboot the servers once a week?
Maybe with temporary slots, but definitely not with permanent slots. I just stopped a replicated pair, and started them up again: Secondary> pg_ctl stop -mfast Primary> pg_ctl stop -mfast Primary> pg_ctl start -w Secondary> pg_ctl start -w Primary> psql -Xc "select * from pg_stat_replication;" Secondary> psql -Xc "select * from pg_stat_wal_receiver;" -- Born in Arizona, moved to Babylonia.
