Restore from a single base backup? #2641
Replies: 1 comment
-
I was able to get a server restored. By starting a single server instance, stopping patroni service (sv stop patroni) as root and stopping server (pg_ctl stop), manually unpack and restore all files into the data directory (as postgres user) and then run "pg_resetwal", delete "backup_label" and then starting the server again. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
I exported a single base backup from my S3 bucket, I did not export any WAL files. I want to inspect the database at the point in time this base backup was done and spun up a temporary cluster and tried to clone from a new S3 bucket where placed the base backup I took. But it doesn't work because it expects some WAL files to be present in the bucket as well. Can I somehow create some dummy WAL files in the bucket that doesn't contain any transactions or can I manually mount the base backup files into a docker container running spilo for example? Note, we only keep 5 backups at a time so I can not clone from the original bucket because it has been removed since it is too old now.
Beta Was this translation helpful? Give feedback.
All reactions