Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <tgl@xxxxxxxxxxxxx> wrote:
"Dhaval Shah" <dhaval.shah.m@xxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux