Re: Frequency of archive_cleanup_command

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: A J <s5aly(at)yahoo(dot)com>
Cc: PG Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Frequency of archive_cleanup_command
Date: 2011-08-10 18:01:18
Message-ID: CA+U5nMLxEo96bBD4F3b=PyzHoddZ1mn7tpDur9qF3h--539bpA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Aug 10, 2011 at 6:36 PM, A J <s5aly(at)yahoo(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-08-10 18:42:25 Re: FW: Character set equivalent for AL32UTF8
Previous Message Jerry Sievers 2011-08-10 17:58:11 Re: Frequency of archive_cleanup_command