Hello Everyone,
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 =60archive_mode =off#We dont
need this aswe will be usingbarman streaming max_wal_senders
=5wal_keep_segments =10wal_log_hints =onhot_standby
=onmax_replication_slots =5synchronous_commit =local|
Also here is what I have in recovery.conf
|standby_mode =onprimary_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