Hi,
On postgresql10, I'm facing issue of "requested WAL segment 000000010000007E0000003F has already been removed" a lot. I resync slaves with pg_basebackup and still some days after the same thing happens with same or other replica node.
I have kept
wal_keep_segment = 1024
wal_buffers = 16MB
min_wal_size = 1GB
max_wal_size = 2GB
archive_mode = on
archive_command = cp %p /var/lib/pgsql/10/archive/%f
wal_level = replica
synchronous_commit = on
synchronous_standby_names = 'pgslave01'
Can I keep wal segments for some duration(eg 24 hours) ?
I'm using two replicas with one in sync and other in potential state.Is one synchronous_standby_names fine?
Is there any option to remove archive wal after 30 days or 50GB?
And how archiving the wal logs help? The missing segment is "000000010000007E0000003F" is in archive dir but how can I make it in use?
Thanks!!
Prince Pathria
Systems Architect
Evive
+91 9478670472
goevive.com
