Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # On the master
- select * from pg_stat_replication ;
- -[ RECORD 1 ]----+----------------------------------------------
- pid | 5399
- usesysid | 16387
- usename | replication
- application_name | walreceiver
- client_addr | XXXXXXXXXXXX
- client_hostname | XXXXXXXXXXXX
- client_port | 56780
- backend_start | 2018-11-05 10:18:50.280663+00
- backend_xmin |
- state | streaming
- sent_lsn | 71/E3000000
- write_lsn | 71/E3000000
- flush_lsn | 71/E3000000
- replay_lsn | 71/E3000000
- write_lag |
- flush_lag |
- replay_lag |
- sync_priority | 0
- sync_state | async
- -[ RECORD 2 ]----+----------------------------------------------
- pid | 10175
- usesysid | 16389
- usename | barman_replication
- application_name | barman_receive_wal
- client_addr | XXXXXXXXXXXX
- client_hostname | XXXXXXXXXXXX
- client_port | 42572
- backend_start | 2018-11-12 03:09:03.715933+00
- backend_xmin |
- state | streaming
- sent_lsn | 71/E3000000
- write_lsn | 71/E3000000
- flush_lsn | 71/E3000000
- replay_lsn |
- write_lag | 00:00:02.516016
- flush_lag | 00:00:02.516016
- replay_lag | 06:28:11.482478
- sync_priority | 0
- sync_state | async
- # On the standby
- select * from pg_replication_slots ;
- -[ RECORD 1 ]-------+------------
- slot_name | barman
- plugin |
- slot_type | physical
- datoid |
- database |
- temporary | f
- active | f
- active_pid |
- xmin |
- catalog_xmin |
- restart_lsn | 16/9F000000
- confirmed_flush_lsn |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement