From: | arvind chikne <arvind(dot)chikne(at)gmail(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Master slave replication |
Date: | 2018-09-19 09:54:08 |
Message-ID: | CAHVLh7Szs=dw+gs+XHF-NbX3gU=DxV9X69b-VueerE8TxLO3AQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi All,
I have successfully configured the master slave replication through WAL,
but after some time my px_xlog and log_archive gets full is there any
option to set the limit for the same
*Error*
*cp: error writing
'/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5': No
space left on device*
*2018-09-19 15:19:19 IST [15642-34394] LOG: archive command failed with
exit code 1*
*2018-09-19 15:19:19 IST [15642-34395] DETAIL: The failed archive command
was: cp pg_xlog/00000001000002E0000000D5
/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5*
*cp: error writing
'/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5': No
space left on device*
*2018-09-19 15:19:20 IST [15642-34396] LOG: archive command failed with
exit code 1*
*2018-09-19 15:19:20 IST [15642-34397] DETAIL: The failed archive command
was: cp pg_xlog/00000001000002E0000000D5
/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5*
*2018-09-19 15:19:20 IST [15642-34398] WARNING: archiving transaction log
file "00000001000002E0000000D5" failed too many times, will try again later*
*cp: error writing
'/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5': No
space left on device*
*2018-09-19 15:19:24 IST [15642-34399] LOG: archive command failed with
exit code 1*
*2018-09-19 15:19:24 IST [15642-34400] DETAIL: The failed archive command
was: cp pg_xlog/00000001000002E0000000D5
/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5*
pls see my postgres.conf
*max_wal_size = 100GB*
*archive_mode = on*
*archive_command = 'cp %p /var/lib/postgresql/9.5/main/log_archive/%f'*
*max_wal_senders = 5 *
*wal_keep_segments = 32 *
*hot_standby = on*
My recovery.conf
*standby_mode = 'on'*
*primary_conninfo = 'host=XXX.XXX.XXX.XXX port=5432 user=rep password=REP'*
*trigger_file = '/tmp/postgresql.trigger.5432'*
*restore_command = 'cp /var/lib/postgresql/9.5/main/log_archive/%f "%p"'*
*archive_cleanup_command = 'pg_archivecleanup
/var/lib/postgresql/9.5/main/log_archive/ %r'*
*-- *
*Thanks & Regards*
Arvind rao chikne
9818979986
*Think Green!!!* Please consider your environmental responsibility before
printing this e-mail
From | Date | Subject | |
---|---|---|---|
Next Message | Fabio Pardi | 2018-09-19 10:14:30 | Re: Master slave replication |
Previous Message | Mariel Cherkassky | 2018-09-19 08:16:45 | Re: sqlite_fdw crashes & errors |