From: Josh Berkus <josh@agliodbs.com>
To: pgsql-docs@postgresql.org
Subject: Re: Missing docs: setting up replication slots for standbys
Date: Wed, 03 Sep 2014 23:06:50 -0700
Message-ID: <5408017A.6000806@agliodbs.com> (raw)
In-Reply-To: <WM!babc8141ab52d0b302c3f85f772d8f8fe3eeb6edcc3a8bb7aa4a77216a995131b95c5e72e8178eaf158573a5b6978ccb!@asav-1.01.com>
References: <5407FBF7.5070204@agliodbs.com>
<20140904060318.GD3625@alap3.anarazel.de>
<WM!babc8141ab52d0b302c3f85f772d8f8fe3eeb6edcc3a8bb7aa4a77216a995131b95c5e72e8178eaf158573a5b6978ccb!@asav-1.01.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
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
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-docs@postgresql.org
Cc: josh@agliodbs.com
Subject: Re: Missing docs: setting up replication slots for standbys
In-Reply-To: <5408017A.6000806@agliodbs.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