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 and if that is the case, how do I avoid crashing
at the REDO DONE? Or is this something to be done at the standby?
Regards
Dhaval
On 4/9/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"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 to back up to the
last checkpoint isn't going to happen if you keep it from crashing at
the REDO DONE point.
regards, tom lane
--
Dhaval Shah
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
