So I had been using the "Time of latest checkpoint" value from
pg_controldata, and freely deleting any archive files that were archived
prior to this time, but it appears as though this is not safe since after
restoring the ".backup" archive file at the start of recovery, I've
accidentally deleted
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