Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated

On 5/31/20 2:43 PM, Andrus wrote:
> Hi!
>
>> In addition to my most recent questions:
>> What are you trying to achieve?
>
> I want to create  hot standby async server using
> /etc/init.d/postgresql stop
> mv /var/lib/postgresql/12/main /var/lib/postgresql/12/mainold
> pg_basebackup --write-recovery-conf -D /var/lib/postgresql/12/main

I don't see where the base backup is being taken from just where it is
going.

> chmod --recursive --verbose 0700 /var/lib/postgresql/12/main
> chown -Rv postgres:postgres /var/lib/postgresql/12/main
> /etc/init.d/postgresql start
>
>> In other words why do a pg_basebackup if you have a standby receiving
>> WALs?
>
> I dont receive WALs.

If you are doing binary replication then you are receiving WALs. It just
a matter of whether you are streaming them or shipping them over complete.

>
> Andrus.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com