Re: Frequency of archive_cleanup_command - Mailing list pgsql-admin

From Simon Riggs
Subject Re: Frequency of archive_cleanup_command
Date
Msg-id CA+U5nMLxEo96bBD4F3b=PyzHoddZ1mn7tpDur9qF3h--539bpA@mail.gmail.com
Whole thread Raw
In response to Frequency of archive_cleanup_command  (A J <s5aly@yahoo.com>)
List pgsql-admin
On Wed, Aug 10, 2011 at 6:36 PM, A J <s5aly@yahoo.com> wrote:

> Couple of questions:
> 1. At what frequency is the archive_cleanup_command executed from the
> recovery.conf file on the standby ?
> 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.

It fails. The gap must be repaired manually, or you're out of luck.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-admin by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: Frequency of archive_cleanup_command
Next
From: Vladimir Protasov
Date:
Subject: Re: Read-only postgres instance