archive falling behind

Поиск
Список
Период
Сортировка
От German Becker
Тема archive falling behind
Дата
Msg-id CALyjCLv-rTPzMZom3EjHRqGUHLE7_MU3Rvn__cooYjrSYAWftA@mail.gmail.com
обсуждение исходный текст
Ответы Re: archive falling behind  (Strahinja Kustudić <strahinjak@nordeus.com>)
Список pgsql-admin
Hi I am working with version 9.1.9. The dabase is in archiving mode. The archives are then sended to a hotstandby replication sever.
I have seen that under heavy load, the archive process will fall behind the WAL generation and thuse some WAL segments won't get archived so the replication stops. To recover from this I need to do a new cold backup and send it to the replication server. Is there a way to limit the WAL generation (i.e slowing down insterts and deletes) so as to prevent the archive from falling behind?

Thanks!!

В списке pgsql-admin по дате отправления:

Предыдущее
От: chanh.tran@free.fr
Дата:
Сообщение: Re: Pb migrating database from Postgres 8.1 to 8.4
Следующее
От: Bill MacArthur
Дата:
Сообщение: Is there any value in using trigger conditions rather than function conditions