Guest User

Untitled

a guest
Nov 12th, 2018
110
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # On the master
  2. select * from pg_stat_replication ;
  3. -[ RECORD 1 ]----+----------------------------------------------
  4. pid | 5399
  5. usesysid | 16387
  6. usename | replication
  7. application_name | walreceiver
  8. client_addr | XXXXXXXXXXXX
  9. client_hostname | XXXXXXXXXXXX
  10. client_port | 56780
  11. backend_start | 2018-11-05 10:18:50.280663+00
  12. backend_xmin |
  13. state | streaming
  14. sent_lsn | 71/E3000000
  15. write_lsn | 71/E3000000
  16. flush_lsn | 71/E3000000
  17. replay_lsn | 71/E3000000
  18. write_lag |
  19. flush_lag |
  20. replay_lag |
  21. sync_priority | 0
  22. sync_state | async
  23. -[ RECORD 2 ]----+----------------------------------------------
  24. pid | 10175
  25. usesysid | 16389
  26. usename | barman_replication
  27. application_name | barman_receive_wal
  28. client_addr | XXXXXXXXXXXX
  29. client_hostname | XXXXXXXXXXXX
  30. client_port | 42572
  31. backend_start | 2018-11-12 03:09:03.715933+00
  32. backend_xmin |
  33. state | streaming
  34. sent_lsn | 71/E3000000
  35. write_lsn | 71/E3000000
  36. flush_lsn | 71/E3000000
  37. replay_lsn |
  38. write_lag | 00:00:02.516016
  39. flush_lag | 00:00:02.516016
  40. replay_lag | 06:28:11.482478
  41. sync_priority | 0
  42. sync_state | async
  43.  
  44. # On the standby
  45. select * from pg_replication_slots ;
  46. -[ RECORD 1 ]-------+------------
  47. slot_name | barman
  48. plugin |
  49. slot_type | physical
  50. datoid |
  51. database |
  52. temporary | f
  53. active | f
  54. active_pid |
  55. xmin |
  56. catalog_xmin |
  57. restart_lsn | 16/9F000000
  58. confirmed_flush_lsn |
RAW Paste Data