Skip to content

Commit 6faaf1b

Browse files
committed
Fix pg_replication_slot example output
The example output of pg_replication_slot is wrong. Correct it and make the output stable by explicitly listing columns to output. Author: Kyotaro Horiguchi <horiguchi.kyotaro@lab.ntt.co.jp> Reviewed-by: Michael Paquier <michael@paquier.xyz> Discussion: https://postgr.es/m/20180731.190909.42582169.horiguchi.kyotaro@lab.ntt.co.jp
1 parent 19df170 commit 6faaf1b

File tree

1 file changed

+4
-4
lines changed

1 file changed

+4
-4
lines changed

doc/src/sgml/high-availability.sgml

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -931,10 +931,10 @@ postgres=# SELECT * FROM pg_create_physical_replication_slot('node_a_slot');
931931
-------------+---------------
932932
node_a_slot |
933933

934-
postgres=# SELECT * FROM pg_replication_slots;
935-
slot_name | slot_type | datoid | database | active | xmin | restart_lsn | confirmed_flush_lsn
936-
-------------+-----------+--------+----------+--------+------+-------------+---------------------
937-
node_a_slot | physical | | | f | | |
934+
postgres=# SELECT slot_name, slot_type, active FROM pg_replication_slots;
935+
slot_name | slot_type | active
936+
-------------+-----------+--------
937+
node_a_slot | physical | f
938938
(1 row)
939939
</programlisting>
940940
To configure the standby to use this slot, <varname>primary_slot_name</>

0 commit comments

Comments
 (0)