Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- FATAL: could not receive data from WAL stream: ERROR: requested WAL segment 0000000200000059000000BA has already been removed
- repuser@[unknown] ERROR: requested WAL segment 0000000200000059000000BA has already been removed
- postgres$ ls -l /db/archivedir/0000000200000059000000BA
- -rw------- 1 postgres postgres 16777216 Mar 31 10:18 /db/archivedir/0000000200000059000000BA
- wal_level = hot_standby
- archive_mode = on
- archive_command = 'test ! -f /db/archivedir/%f && cp %p /db/archivedir/%f'
- max_wal_senders = 3
- brp=# SELECT * FROM pg_replication_slots;
- slot_name | plugin | slot_type | datoid | database | active | active_pid | xmin | catalog_xmin | restart_lsn
- ----------+--------+-----------+--------+----------+--------+------------+------+--------------+-------------
- brp_uk | | physical | | | f | | | |
- hot_standby = on
- standby_mode = on
- primary_conninfo = 'host=xxx port=5434 user=repuser password=xxx'
- trigger_file = '/tmp/postgresql.trigger.5434'
- primary_slot_name = 'brp_uk'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement