From: John Scalia <jayknowsunix@gmail.com>
To: Matheus de Oliveira <matioli.matheus@gmail.com>
To: thomas simon <tsimon@neteven.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Pg_basebackup does not do aything
Date: Thu, 26 Jun 2014 13:16:04 -0400
Message-ID: <53AC5554.2030603@gmail.com> (raw)
In-Reply-To: <CAJghg4LOTYVyKdR2O8rcPx5rDjOhAC9Dz+hK608pS-mG2qNH5w@mail.gmail.com>
References: <53AB29E8.6010209@neteven.com>
<CAJghg4LJi+oFOem47ocEnQvB_1KNr6NT1wzpFMPhU0D_BZtKuA@mail.gmail.com>
<53AB4C02.1030907@neteven.com>
<CAJghg4LOTYVyKdR2O8rcPx5rDjOhAC9Dz+hK608pS-mG2qNH5w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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 the files it need from archiving.
>
According to the postgresql documentation at 25.2.3 Preparing the Master for Standby Servers, Set up continuous archiving on 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 setup ssh 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 of the 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jayknowsunix@gmail.com, matioli.matheus@gmail.com, tsimon@neteven.com
Subject: Re: Pg_basebackup does not do aything
In-Reply-To: <53AC5554.2030603@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox