I'm trying to configure continuous backup solution using pg_probackup tool. So far I did the following:
- Configured
archive_commandaccording to the docs - Created backup using
pg_probackup backupcommand with astreammode - Restored using
pg_probackup restoreon another computer
However, I failed to restore database backup by manually copying files and setting restore_command in recovery.conf. Here's what I've done:
- Created new data dir and copied files from
pg_probackupto that dir - Created
recovery.confwithrestore_commandset to (I'm using Postgres on Windows so paths are Windows-style)'"<path to pg_probackup.exe>" archive-get -B <backup dir> --instance <instancename> --wal-file-path "%p" --wal-file-name %f' - Started Postgres server
As far as I can see recovery went fine - server is running. However, there're errors in the log file:
ERROR: invalid page in block 0 of relation global/1262
and I assume something went wrong with recovery after all.
Can anyone please tell me what I'm doing wrong here?