I'm trying to configure continuous backup solution using pg_probackup tool. So far I did the following:
archive_commandaccording to the docs
- Created backup using
pg_probackup backupcommand with a
- Restored using
pg_probackup restoreon another computer
However, I failed to restore database backup by manually copying files and setting
recovery.conf. Here's what I've done:
- Created new data dir and copied files from
pg_probackupto that dir
restore_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?