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(at)gmail(dot)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.