Re: [GENERAL] restore_command %r option

2008-03-17 Thread Steven Flatt
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

Re: [GENERAL] restore_command %r option

2008-03-10 Thread Steven Flatt
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