From 2b5788b3f1ecf4ebd31cf36eecdd4619cf3f394e Mon Sep 17 00:00:00 2001 From: Kyotaro Horiguchi Date: Wed, 1 Aug 2018 12:41:03 +0900 Subject: [PATCH] Documentation fix of "Log-Shipping Standy Servers" for PG95. The example output of pg_replication_slot is wrong. Correct and make the output stable by explicitly specifying a part of the all columns in pg_replication_slots. --- doc/src/sgml/high-availability.sgml | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index 35daf0103a..ae831192d0 100644 --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -931,10 +931,10 @@ postgres=# SELECT * FROM pg_create_physical_replication_slot('node_a_slot'); -------------+--------------- node_a_slot | -postgres=# SELECT * FROM pg_replication_slots; - slot_name | slot_type | datoid | database | active | xmin | restart_lsn --------------+-----------+--------+----------+--------+------+------------- - node_a_slot | physical | | | f | | +postgres=# SELECT slot_name, slot_type, active, restart_lsn FROM pg_replication_slots; + slot_name | slot_type | active | restart_lsn +-------------+-----------+--------+------------- + node_a_slot | physical | f | (1 row) To configure the standby to use this slot, primary_slot_name -- 2.16.3