Re: Master slave replication
| От | Fabio Pardi |
|---|---|
| Тема | Re: Master slave replication |
| Дата | |
| Msg-id | 9f01bf5f-02c7-33d8-936b-0188e853e5aa@portavita.eu обсуждение исходный текст |
| Ответ на | Master slave replication (arvind chikne <arvind.chikne@gmail.com>) |
| Ответы |
Re: Master slave replication
(arvind chikne <arvind.chikne@gmail.com>)
|
| Список | pgsql-admin |
Hi Arvind,
From what you describe, looks like you are sharing WAL and archive under the same partition. It is not good idea.
A lot depends from how much disk space you have available and how you setup the disks, but from what i see, max_wal_size in your configuration is quite big. I would set it to something smaller, and make sure that archive, data and pg_xlog are on different partitions or better, disks
https://www.postgresql.org/docs/9.5/static/runtime-config-wal.html#GUC-MAX-WAL-SIZE
regards,
fabio pardi
From what you describe, looks like you are sharing WAL and archive under the same partition. It is not good idea.
A lot depends from how much disk space you have available and how you setup the disks, but from what i see, max_wal_size in your configuration is quite big. I would set it to something smaller, and make sure that archive, data and pg_xlog are on different partitions or better, disks
https://www.postgresql.org/docs/9.5/static/runtime-config-wal.html#GUC-MAX-WAL-SIZE
regards,
fabio pardi
On 19/09/18 11:54, arvind chikne wrote:
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 sameErrorcp: error writing '/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5': No space left on device2018-09-19 15:19:19 IST [15642-34394] LOG: archive command failed with exit code 12018-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/00000001000002E0000000D5cp: error writing '/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5': No space left on device2018-09-19 15:19:20 IST [15642-34396] LOG: archive command failed with exit code 12018-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/00000001000002E0000000D52018-09-19 15:19:20 IST [15642-34398] WARNING: archiving transaction log file "00000001000002E0000000D5" failed too many times, will try again latercp: error writing '/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5': No space left on device2018-09-19 15:19:24 IST [15642-34399] LOG: archive command failed with exit code 12018-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/00000001000002E0000000D5pls see my postgres.confmax_wal_size = 100GBarchive_mode = onarchive_command = 'cp %p /var/lib/postgresql/9.5/main/log_archive/%f'max_wal_senders = 5wal_keep_segments = 32hot_standby = onMy recovery.confstandby_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 chikne9818979986Think Green!!! Please consider your environmental responsibility before printing this e-mail
В списке pgsql-admin по дате отправления: