archive falling behind - Mailing list pgsql-admin

From German Becker
Subject archive falling behind
Date
Msg-id CALyjCLv-rTPzMZom3EjHRqGUHLE7_MU3Rvn__cooYjrSYAWftA@mail.gmail.com
Whole thread Raw
Responses Re: archive falling behind  (Strahinja Kustudić <strahinjak@nordeus.com>)
List 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 by date:

Previous
From: chanh.tran@free.fr
Date:
Subject: Re: Pb migrating database from Postgres 8.1 to 8.4
Next
From: Bill MacArthur
Date:
Subject: Is there any value in using trigger conditions rather than function conditions