From: Jerry Sievers <gsievers19@comcast.net>
To: A J <s5aly@yahoo.com>
Cc: PG Admin <pgsql-admin@postgresql.org>
Subject: Re: Frequency of archive_cleanup_command
Date: Wed, 10 Aug 2011 13:58:11 -0400
Message-ID: <87y5z1jgi4.fsf@comcast.net> (raw)
In-Reply-To: <1312997800.60712.YahooMailNeo@web120016.mail.ne1.yahoo.com>
References: <1312997800.60712.YahooMailNeo@web120016.mail.ne1.yahoo.com>
A J <s5aly@yahoo.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsievers19@comcast.net, s5aly@yahoo.com
Subject: Re: Frequency of archive_cleanup_command
In-Reply-To: <87y5z1jgi4.fsf@comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox