- Notifications
You must be signed in to change notification settings - Fork86
Description
Hello, I am attempting to test a recovery of a 12.3 postgres cluster installed on windows server 2016
from an archive backup that I have set up using version 2.4.1
When I run the restore command everything seems to work but when I attempt to start the service it immediately stops.
When I check the postgres log file it it contains the following:
2020-08-10 14:36:32.524 EDT [256] LOG: database system was interrupted; last known up at 2020-07-30 09:19:12 EDT
2020-08-10 14:36:33.400 EDT [256] LOG: starting archive recovery
INFO: pg_probackup archive-get WAL file: 00000001000000130000009C, remote: none, threads: 1/1, batch: 1
ERROR: pg_probackup archive-get failed to deliver WAL file: 00000001000000130000009C, time elapsed: 1ms
2020-08-10 14:36:33.433 EDT [256] LOG: invalid checkpoint record
2020-08-10 14:36:33.434 EDT [256] FATAL: could not locate required checkpoint record
2020-08-10 14:36:33.434 EDT [256] HINT: If you are restoring from a backup, touch "F:/PostgresData/recovery.signal" and add required recovery options.
If you are not restoring from a backup, try removing the file "F:/PostgresData/backup_label".
Be careful: removing "F:/PostgresData/backup_label" will result in a corrupt cluster if restoring from a backup.
2020-08-10 14:36:33.440 EDT [4400] LOG: startup process (PID 256) exited with exit code 1
2020-08-10 14:36:33.440 EDT [4400] LOG: aborting startup due to startup process failure
2020-08-10 14:36:33.450 EDT [4400] LOG: database system is shut down
I have checked and the file 00000001000000130000009C is present in the WAL archive.