From: | Vijay Rajah <me(at)rvijay(dot)me> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Postgres replication -- .done file in slave |
Date: | 2018-08-08 15:21:23 |
Message-ID: | fc2ebb88-d818-aada-7bef-2b29ca34ea2d@rvijay.me |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Browne | 2018-08-08 17:16:40 | Re: Postgres - search for value throughout many tables? |
Previous Message | czezz | 2018-08-08 15:05:45 | Odp: Re: Postgres - search for value throughout many tables? |