Re: [GENERAL] Determining oldest WAL for Archiving PITR Standby - SOLVED

2007-10-18 Thread Brian Wipf
On 17-Oct-07, at 12:01 AM, Brian Wipf wrote: I'm working on a script that takes backups in intervals from our warm PITR stand by server (both servers running PG 8.2.5). The documentation advises running pg_controldata on the standby server to inspect the control file and determine the

Re: [GENERAL] Determining oldest WAL for Archiving PITR Standby - SOLVED

2007-10-18 Thread Brian Wipf
On 18-Oct-07, at 3:15 PM, Brian Wipf wrote: The offset is the last 6 hex digits of the checkpoint location value. The offset contains leading zeros to make it 6 digits if its actual value is less than 6 digits. Therefore, the digits between the slash and the last 6 digits are the log