Search Postgresql Archives

Switchover : WAL archiving and shutdown...

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

 



Hi,

I'm setting up switchover (to another server) with WAL/PITR.

But, I'm wondering what could be the behaviour of Postgresql if you shutdown the service while a new WAL archive is just ready to be copied, or if the transfer is in
progress...
Will the tranfer be canceled (until the next start), or will Postgresql wait for the end
of the transfer before exiting ?

In other words, when I want to switchover, is it sufficient to stop postgresql, and rsync the last partial WAL (the last modified one), or do I have to check if
every WAL file is in sync before starting the other server ??


Thank you in advance,
Philippe Ferreira


[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