Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M8089=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1XPQCB-0003F7-S7
 for pgsql-docs@arkaria.postgresql.org; Thu, 04 Sep 2014 06:06:59 +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+M8089=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1XPQCB-0004iR-Ba
 for pgsql-docs@arkaria.postgresql.org; Thu, 04 Sep 2014 06:06:59 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <josh@agliodbs.com>) id 1XPQCA-0004hs-No
 for pgsql-docs@postgresql.org; Thu, 04 Sep 2014 06:06:58 +0000
Received: from 01.zmailcloud.com ([192.198.85.104]
 helo=mx-out-1.zmailcloud.com)
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <josh@agliodbs.com>) id 1XPQC6-0003TU-QY
 for pgsql-docs@postgresql.org; Thu, 04 Sep 2014 06:06:57 +0000
Received: from smtp.01.com (smtp.01.com [10.10.0.43])
 by mx-out-1.zmailcloud.com (Postfix) with ESMTP id C2F47564A7E
 for <pgsql-docs@postgresql.org>; Thu,  4 Sep 2014 01:06:53 -0500 (CDT)
Received: from localhost (localhost [127.0.0.1])
 by smtp-out-1.01.com (Postfix) with ESMTP id 96D90A01C2
 for <pgsql-docs@postgresql.org>; Thu,  4 Sep 2014 01:06:53 -0500 (CDT)
X-Virus-Scanned: amavisd-new at smtp-out-1.01.com
Received: from smtp.01.com ([127.0.0.1])
 by localhost (smtp-out-1.01.com [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id QRhag2q2cWKa for <pgsql-docs@postgresql.org>;
 Thu,  4 Sep 2014 01:06:53 -0500 (CDT)
Received: from smtp.01.com (localhost [127.0.0.1])
 by smtp-out-1.01.com (Postfix) with ESMTP id 42B51A0291
 for <pgsql-docs@postgresql.org>; Thu,  4 Sep 2014 01:06:53 -0500 (CDT)
Received: from localhost (localhost [127.0.0.1])
 by smtp-out-1.01.com (Postfix) with ESMTP id E79FCA028F
 for <pgsql-docs@postgresql.org>; Thu,  4 Sep 2014 01:06:52 -0500 (CDT)
X-Virus-Scanned: amavisd-new at smtp-out-1.01.com
Received: from smtp.01.com ([127.0.0.1])
 by localhost (smtp-out-1.01.com [127.0.0.1]) (amavisd-new, port 10026)
 with ESMTP id aJwteWDHpXOC for <pgsql-docs@postgresql.org>;
 Thu,  4 Sep 2014 01:06:52 -0500 (CDT)
Received: from [10.0.0.165] (c-50-139-39-6.hsd1.or.comcast.net [50.139.39.6])
 by smtp-out-1.01.com (Postfix) with ESMTPSA id 31C2AA01C2
 for <pgsql-docs@postgresql.org>; Thu,  4 Sep 2014 01:06:51 -0500 (CDT)
Message-ID: <5408017A.6000806@agliodbs.com>
Date: Wed, 03 Sep 2014 23:06:50 -0700
From: Josh Berkus <josh@agliodbs.com>
Organization: PostgreSQL Experts Inc.
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.5.0
MIME-Version: 1.0
To: pgsql-docs@postgresql.org
Subject: Re: Missing docs: setting up replication slots for standbys
References: <5407FBF7.5070204@agliodbs.com>
 <20140904060318.GD3625@alap3.anarazel.de>
 <WM!babc8141ab52d0b302c3f85f772d8f8fe3eeb6edcc3a8bb7aa4a77216a995131b95c5e72e8178eaf158573a5b6978ccb!@asav-1.01.com>
In-Reply-To: 
 <WM!babc8141ab52d0b302c3f85f772d8f8fe3eeb6edcc3a8bb7aa4a77216a995131b95c5e72e8178eaf158573a5b6978ccb!@asav-1.01.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -1.9 (-)
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

On 09/03/2014 11:03 PM, Andres Freund wrote:
> It actually is explained. I don't have a built source handy right now,
> so chapter numbers... But at least the following is there:
> 
>    <sect3 id="streaming-replication-slots-config">
>     <title>Configuration Example</title>
>     <para>
>      You can create a replication slot like this:
> <programlisting>
> postgres=# SELECT * FROM pg_create_physical_replication_slot('node_a_slot');
>   slot_name  | xlog_position
> -------------+---------------
>  node_a_slot |
> 
> postgres=# SELECT * FROM pg_replication_slots;
>   slot_name  | slot_type | datoid | database | active | xmin | restart_lsn
> -------------+-----------+--------+----------+--------+------+-------------
>  node_a_slot | physical  |        |          | f      |      |
> (1 row)
> </programlisting>
>      To configure the standby to use this slot, <varname>primary_slot_name</>
>      should be configured in the standby's <filename>recovery.conf</>.
>      Here is a simple example:
> <programlisting>
> standby_mode = 'on'
> primary_conninfo = 'host=192.168.1.50 port=5432 user=foo password=foopass'
> primary_slot_name = 'node_a_slot'
> </programlisting>
> 
> and I'm pretty sure primary_slot_name and such is configured at the
> appropriate place too.

Huh.  I can't seem to find any way to navigate to that page.  What is it
supposed to be under?


-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


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