Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id C427AB5DC08 for ; Wed, 10 Aug 2011 15:04:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 77685-01-9 for ; Wed, 10 Aug 2011 18:04:11 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qmta05.westchester.pa.mail.comcast.net (qmta05.westchester.pa.mail.comcast.net [76.96.62.48]) by mail.postgresql.org (Postfix) with ESMTP id B0814B5F71D for ; Wed, 10 Aug 2011 14:58:13 -0300 (ADT) Received: from omta17.westchester.pa.mail.comcast.net ([76.96.62.89]) by qmta05.westchester.pa.mail.comcast.net with comcast id Jh1Y1h0081vXlb855hyDs9; Wed, 10 Aug 2011 17:58:13 +0000 Received: from homie ([68.45.149.190]) by omta17.westchester.pa.mail.comcast.net with comcast id JhyC1h00x46izrY3dhyC3D; Wed, 10 Aug 2011 17:58:13 +0000 Received: by homie (Postfix, from userid 1000) id 92BF5181A64; Wed, 10 Aug 2011 13:58:11 -0400 (EDT) To: A J Cc: PG Admin Subject: Re: Frequency of archive_cleanup_command References: <1312997800.60712.YahooMailNeo@web120016.mail.ne1.yahoo.com> From: Jerry Sievers Date: Wed, 10 Aug 2011 13:58:11 -0400 In-Reply-To: <1312997800.60712.YahooMailNeo@web120016.mail.ne1.yahoo.com> (A. J.'s message of "Wed\, 10 Aug 2011 10\:36\:40 -0700 \(PDT\)") Message-ID: <87y5z1jgi4.fsf@comcast.net> User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.2 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.681 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=0.1, FREEMAIL_FROM=0.001, FREEMAIL_REPLY=1.929, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.811 X-Spam-Level: X-Archive-Number: 201108/86 X-Sequence-Number: 38073 A J writes: > Couple of questions: 1. At what frequency is the > archive_cleanup_command executed from the recovery.conf file on the > standby ? Typically once per WAL file being processed. > 2. If for some reason lets say a WAL file is missing from the > archive directory but the files after that are present. When the > standby tries to restore the missing WAL file, does it fail or it > simply skips the missing WAL file and goes to the next one. Neither. A standby will sit waiting forever for the next WAL segment that it needs. You can't just skip missing WALs :-) HTH > Thanks. > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net p: 305.321.1144