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 segmen

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 curre

[GENERAL] Determining oldest WAL for Archiving PITR Standby

2007-10-16 Thread Brian Wipf
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 current checkpoint WAL location". I am hoping som