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@xxxxxxxxx> 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