On 10/24/23 13:31, Brad White 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.