Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M7985=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1WbaUr-00079K-VH
 for pgsql-docs@arkaria.postgresql.org; Sat, 19 Apr 2014 19:00:18 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M7985=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1WbaUr-0002zg-BZ
 for pgsql-docs@arkaria.postgresql.org; Sat, 19 Apr 2014 19:00:17 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <bruce@momjian.us>) id 1WbaUp-0002vl-Lo
 for pgsql-docs@postgresql.org; Sat, 19 Apr 2014 19:00:15 +0000
Received: from momjian.us ([72.94.173.45])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <bruce@momjian.us>) id 1WbaUm-0006UW-NU
 for pgsql-docs@postgresql.org; Sat, 19 Apr 2014 19:00:15 +0000
Received: from bruce by momjian.us with local (Exim 4.72)
 (envelope-from <bruce@momjian.us>)
 id 1WbaUl-00055K-Jr; Sat, 19 Apr 2014 15:00:11 -0400
Date: Sat, 19 Apr 2014 15:00:11 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Craig Ringer <craig@2ndquadrant.com>
Cc: PostgreSQL Developers <pgsql-docs@postgresql.org>
Subject: Re: archive_command vs recovery_command paths
Message-ID: <20140419190011.GC23526@momjian.us>
References: <52FC0FB2.1030705@2ndquadrant.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="2B/JsCI69OhZNC5r"
Content-Disposition: inline
In-Reply-To: <52FC0FB2.1030705@2ndquadrant.com>
User-Agent: Mutt/1.5.20 (2009-06-14)
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org


--2B/JsCI69OhZNC5r
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Thu, Feb 13, 2014 at 08:20:02AM +0800, Craig Ringer wrote:
> Hi folks
> 
> Another point of confusion I've been seeing a lot in users on Stack
> Overflow, dba.stackexchange.com, etc surrounds the meaning of paths
> given in archive_command and restore_command.
> 
> Lots of people seem to assume that they are both relative to the master,
> and that the master will run the restore_command to fetch archives to
> send to the replica on request.
> 
> (Yes, I know that's completely missing the point of archive-based
> replication, but it seems common).
> 
> So I think docs changes are needed to the explanations of those options,
> and to the replication/recovery section, that better explain that we
> assume there's shared storage like NFS involved, and if there isn't you
> need to use commands like scp/rsync instead, or use tools like WAL-E.
> 
> I'm not going to get time to do this one for at least a few days, but
> I'm posting it now partly so I don't forget about it.

I have applied the attached patch which at least clarifies this issue.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

--2B/JsCI69OhZNC5r
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment; filename="local.diff"

diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
new file mode 100644
index 17ef25b..4a33f87
*** a/doc/src/sgml/config.sgml
--- b/doc/src/sgml/config.sgml
*************** include 'filename'
*** 2279,2285 ****
        </indexterm>
        <listitem>
         <para>
!         The shell command to execute to archive a completed WAL file
          segment.  Any <literal>%p</> in the string is
          replaced by the path name of the file to archive, and any
          <literal>%f</> is replaced by only the file name.
--- 2279,2285 ----
        </indexterm>
        <listitem>
         <para>
!         The local shell command to execute to archive a completed WAL file
          segment.  Any <literal>%p</> in the string is
          replaced by the path name of the file to archive, and any
          <literal>%f</> is replaced by only the file name.
diff --git a/doc/src/sgml/recovery-config.sgml b/doc/src/sgml/recovery-config.sgml
new file mode 100644
index 9335aca..c9ed2df
*** a/doc/src/sgml/recovery-config.sgml
--- b/doc/src/sgml/recovery-config.sgml
***************
*** 42,48 ****
        </indexterm>
        <listitem>
         <para>
!         The shell command to execute to retrieve an archived segment of
          the WAL file series. This parameter is required for archive recovery,
          but optional for streaming replication.
          Any <literal>%f</> in the string is
--- 42,48 ----
        </indexterm>
        <listitem>
         <para>
!         The local shell command to execute to retrieve an archived segment of
          the WAL file series. This parameter is required for archive recovery,
          but optional for streaming replication.
          Any <literal>%f</> in the string is

--2B/JsCI69OhZNC5r
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

--2B/JsCI69OhZNC5r--