1

I'm trying to configure continuous backup solution using pg_probackup tool. So far I did the following:

  1. Configured archive_command according to the docs
  2. Created backup using pg_probackup backup command with a stream mode
  3. Restored using pg_probackup restore on 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:

  1. Created new data dir and copied files from pg_probackup to that dir
  2. Created recovery.conf with restore_command set 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'
  3. 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?

Alexander
  • 181
  • 1
  • 7

0 Answers0