Re: setting up streaming replication

[Ron]

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.