On Sun, Dec 31, 2017 at 10:22:37AM +0300, Sergey Burladyan wrote: > Michael Paquier <michael.paqu...@gmail.com> writes: >> Don't be surprised if you get corrupted instances or that you >> are not able to recover up to a consistent point if you need to roll in >> a backup. > > But only if archive was reboot unexpectedly, am I right?
Or unplugged, which happens quite often because of human mistakes. Maintaining scripts that do backup and restore require quite a lot of specialized knowledge. Solutions like barman, WAL-E or pgBackRest, or even what in-core has with say pg_receivewal are battle-proven and have hundreds of man-hours behind from many people. I suspect that there are other gems hidden in your scripts. So be careful. -- Michael
signature.asc
Description: PGP signature
