Re: How to start slave after pg_basebackup. Why min_wal_size andwal_keep_segments are duplicated - Mailing list pgsql-general

From Adrian Klaver
Subject Re: How to start slave after pg_basebackup. Why min_wal_size andwal_keep_segments are duplicated
Date
Msg-id 16629afe-a53c-76e4-ef1e-a0a5ceba2d71@aklaver.com
Whole thread Raw
In response to Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
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.klaver@aklaver.com



pgsql-general by date:

Previous
From: Stefan Keller
Date:
Subject: Re: Oracle vs. PostgreSQL - a comment
Next
From: Stefan Knecht
Date:
Subject: Re: Oracle vs. PostgreSQL - a comment