Postgres Pro
Downloads
Home   >   mailing lists

Re: restore_command %r option - Mailing list pgsql-general

From Steven Flatt
Subject Re: restore_command %r option
Date
Msg-id 357fa7590803100923i5b99c968yfc29c0674b7784fe@mail.gmail.com
Whole thread Raw
In response to restore_command %r option  ("Steven Flatt" <steven.flatt@gmail.com>)
Responses Re: restore_command %r option  ("Steven Flatt" <steven.flatt@gmail.com>)
List pgsql-general
Tree view
Well, after some testing, it appears as though the %r option is not supported on 8.2.4.
 
It also looks as though pg_controldata may have the answer I want, but what is the best programmatic way to determine the earliest archive file that I need to keep?
 
Thanks,
Steve

On Mon, Mar 10, 2008 at 11:32 AM, Steven Flatt <steven.flatt@gmail.com> wrote:
Is the %r option of the restore_command available in PG 8.2.4?  If not, is there any other way to know how many archive files need to be kept on the standby server when in recovery mode?
 
Thanks,
Steve

pgsql-general by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: [PERFORM] multi-threaded pgloader makes it in version 2.3.0
Next
From: Craig Ringer
Date:
Subject: Re: ISO something like "#if 0 ... #endif" for SQL code