Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3445A634300 for ; Thu, 11 Mar 2010 09:20:14 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 83712-08 for ; Thu, 11 Mar 2010 13:20:03 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp165.iad.emailsrvr.com (smtp165.iad.emailsrvr.com [207.97.245.165]) by mail.postgresql.org (Postfix) with ESMTP id CF4BB632CA7 for ; Thu, 11 Mar 2010 09:20:03 -0400 (AST) Received: from relay26.relay.iad.mlsrvr.com (localhost [127.0.0.1]) by relay26.relay.iad.mlsrvr.com (SMTP Server) with ESMTP id 719A81B49BE for ; Thu, 11 Mar 2010 08:20:02 -0500 (EST) Received: by relay26.relay.iad.mlsrvr.com (Authenticated sender: chander-AT-otg-nc.com) with ESMTPSA id C1BD31B49CA for ; Thu, 11 Mar 2010 08:20:01 -0500 (EST) Message-ID: <4B98EDF9.1020800@otg-nc.com> Date: Thu, 11 Mar 2010 08:19:53 -0500 From: Chander Ganesan User-Agent: Thunderbird 2.0.0.23 (Windows/20090812) MIME-Version: 1.0 To: pgsql-testers@postgresql.org Subject: Documentation/Cleanup Command for Hot Standby Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/6 X-Sequence-Number: 55 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... -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 919-463-0999/877-258-8987 http://www.otg-nc.com