Advertisement
Guest User

Untitled

a guest
Mar 31st, 2017
1,096
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. FATAL: could not receive data from WAL stream: ERROR: requested WAL segment 0000000200000059000000BA has already been removed
  2.  
  3. repuser@[unknown] ERROR: requested WAL segment 0000000200000059000000BA has already been removed
  4.  
  5. postgres$ ls -l /db/archivedir/0000000200000059000000BA
  6. -rw------- 1 postgres postgres 16777216 Mar 31 10:18 /db/archivedir/0000000200000059000000BA
  7.  
  8. wal_level = hot_standby
  9. archive_mode = on
  10. archive_command = 'test ! -f /db/archivedir/%f && cp %p /db/archivedir/%f'
  11. max_wal_senders = 3
  12.  
  13. brp=# SELECT * FROM pg_replication_slots;
  14. slot_name | plugin | slot_type | datoid | database | active | active_pid | xmin | catalog_xmin | restart_lsn
  15. ----------+--------+-----------+--------+----------+--------+------------+------+--------------+-------------
  16. brp_uk | | physical | | | f | | | |
  17.  
  18. hot_standby = on
  19.  
  20. standby_mode = on
  21. primary_conninfo = 'host=xxx port=5434 user=repuser password=xxx'
  22. trigger_file = '/tmp/postgresql.trigger.5434'
  23. primary_slot_name = 'brp_uk'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement