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
-
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