From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Chander Ganesan <chander(at)otg-nc(dot)com> |
Cc: | pgsql-testers(at)postgresql(dot)org |
Subject: | Re: Documentation/Cleanup Command for Hot Standby |
Date: | 2010-03-11 18:44:35 |
Message-ID: | 4B993A13.9070506@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-testers |
On 3/11/10 5:19 AM, Chander Ganesan wrote:
> Hi,
>
> I've been reviewing HS/SR and have a couple of thoughts/notes:
>
> - The recovery_done_command is not documented (that I can find, at
> least) in the documentation.
> - There is (presently) no way to have PostgreSQL's standby node "clean
> up" unneeded WAL files (the %r parameter for archive_command). I saw
> some talk about adding a 'archive_cleanup_command' to recovery.conf, but
> that doesn't seem to work (yet). I think this should be listed as a
> to-do item on the wiki for this application (or if it was added after
> the alpha4 release, noted as a completed item.) Without a way to
> cleanup archives, the wal archive could end up getting very large, and
> even fill up the file system it is on...
Yes, a lot of this is going to be very manual for 9.0. I'm working on
documentation on how you can decide what to delete via cron job.
--Josh Berkus
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2010-03-14 21:38:04 | April 3: Test-Fest Day |
Previous Message | Chander Ganesan | 2010-03-11 13:19:53 | Documentation/Cleanup Command for Hot Standby |