Re: Missing docs: setting up replication slots for standbys

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