Re: [GENERAL] Errors during recovery of a postgres. Need some help understanding them...

2007-04-10 Thread Dhaval Shah
I am still learning the ropes, I guess. I am not able to understand the following: The attempt to back up to the last checkpoint isn't going to happen if you keep it from crashing at the REDO DONE point. Does the above statement mean that I am crashing my primary server at the REDO DONE point

Re: [GENERAL] Errors during recovery of a postgres. Need some help understanding them...

2007-04-09 Thread Tom Lane
"Dhaval Shah" <[EMAIL PROTECTED]> writes: > The question I have is, how far does it look behind in time? I think you only need to hang onto the immediately preceding file; it only backs up to the last applied WAL record, and that's certainly not going to span multiple segment files. The attempt t

[GENERAL] Errors during recovery of a postgres. Need some help understanding them...

2007-04-09 Thread Dhaval Shah
Here is the situation: I have a standby postgres which is fed a WAL File every 2 minutes. Whenever it is fed a WAL file it logs the following: --- LOG: restored log file "00010070" from archive pg_restore::copyWALFile: Moving /opt/data/mirror/00010071 to pg_xlog