Re: Pg_basebackup does not do aything - Mailing list pgsql-admin

From John Scalia
Subject Re: Pg_basebackup does not do aything
Date
Msg-id 53AC5554.2030603@gmail.com
Whole thread Raw
In response to Re: Pg_basebackup does not do aything  (Matheus de Oliveira <matioli.matheus@gmail.com>)
List pgsql-admin
From your last message:
> It is recommended to configure it to grab archive files from somewhere (can be from other node) if you have archiving
enabled.So, if the receiver can't keep up with the sender  
> (e.g. when the WAL files are rotated and the sender does not have the files the receiver wants anymore), it can get
thefiles it need from archiving. 
>
According to the postgresql documentation at 25.2.3 Preparing the Master for Standby Servers, Set up continuous
archivingon the primary to an archive directory accessible from the  
standby.

I took this to mean the archive_command = "scp %p postgres@<IP of standby>:/<directory on standby>"

And yes, you can add a ";" at the end of this and specify a second server. That's what I'm doing. Oh, and you have to
setupssh keyrings so the scp will not prompt for a password.  
Anyway, I got the impression that the primary should push and the standby's should not pull WAL segments from this part
ofthe docs. Although, I can see how you could just specify  
the scp in the restore_command and do the pull. I just don't know the safety of doing that.
--
Jay


pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: Wal archive way behind in streaming replication
Next
From: Oliver
Date:
Subject: Re: [pgadmin-support] Best backup strategy for production systems