I have a postgres 9.5 with Master slave setup. The slave is a
streaming replication client.
I have a lot ( >100k ) of .done files in my slave's
pg_xlog/archive_status/ directory
Since this is a streaming replication I have disabled
archive_mode in both master & slave. Also, I use barman for
backup, which also uses streaming backup for backups.
Here is my relevant part of postgresql .conf file
wal_level = hot_standby
archive_timeout = 60
archive_mode = off #We dont need this as we will be using barman streaming
max_wal_senders = 5
wal_keep_segments = 10
wal_log_hints = on
hot_standby = on
max_replication_slots = 5
synchronous_commit = local
Also here is what I have in recovery.conf
standby_mode = on
primary_conninfo = 'host=10.xx.xxx.xx port=5432 user=replication password=****** application_name=salve_syncstdby'
trigger_file = '/<datadir>/make_me_master'
archive_cleanup_command = '/usr/pgsql-9.5/bin/pg_archivecleanup </WALDIR> %r'
primary_slot_name = 'slave_repl'
recovery_target_timeline = latest
restore_command = '/usr/bin/barman-wal-restore -p 4 -s <Barman_IP> -U barman <db_name> %f %p'
Is it ok to clear the .done files?
-Thanks in advance
Vijay
PS: I have posted the same question in
https://stackoverflow.com/questions/51725092/postgres-replication-done-file-in-slave
