On Tue, Jul 31, 2018 at 10:59:14AM -0400, Alvaro Herrera wrote: > How about pasting it like this? > > alvherre=# select * from pg_replication_slots \gx > ─[ RECORD 1 ]───────┬──────────── > slot_name │ node_a_slot > plugin │ > slot_type │ physical > datoid │ > database │ > temporary │ f > active │ f > active_pid │ > xmin │ > catalog_xmin │ > restart_lsn │ > confirmed_flush_lsn │
Each time this catalog is changed, this would become incorrect. My suggestion would be to change the query to that and call it a day: SELECT slot_name, slot_type, active FROM pg_replication_slots; -- Michael
signature.asc
Description: PGP signature
