Re: setting up streaming replication

On 10/24/23 13:31, Brad White wrote:

On Tue, Oct 24, 2023 at 8:56 AM Ron <ronljohnsonjr@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;"