Uh oh!
There was an error while loading.Please reload this page.
- Notifications
You must be signed in to change notification settings - Fork236
Closed
Assignees
Labels
Description
Please provide the following information when submitting an issue (feature requests or general comments can skip this):
- pgBackRest version:
version 2.25
- PostgreSQL version:
12.3
- Operating system/version - if you have more than one server (for example, a database server, a repository host server, one or more standbys), please specify each:
CentOS 7
- Did you install pgBackRest from source or from a package?
package (CrunchyData Postgres Operator)
- Please attach the following as applicable:
Stanza-create fails with this:
time="2020-06-10T16:47:04Z" level=info msg="pgo-backrest starts"time="2020-06-10T16:47:04Z" level=info msg="debug flag set to false"time="2020-06-10T16:47:04Z" level=info msg="backrest stanza-create command requested"time="2020-06-10T16:47:04Z" level=info msg="backrest command will be executed for both local and s3 storage"time="2020-06-10T16:47:04Z" level=info msg="command to execute is [pgbackrest stanza-create --db-host=172.18.0.13 --db-path=/pgdata/hippo && pgbackrest stanza-create --db-host=172.18.0.13 --db-path=/pgdata/hippo --repo-type=s3]"time="2020-06-10T16:47:04Z" level=info msg="command is pgbackrest stanza-create --db-host=172.18.0.13 --db-path=/pgdata/hippo && pgbackrest stanza-create --db-host=172.18.0.13 --db-path=/pgdata/hippo --repo-type=s3 "time="2020-06-10T16:47:06Z" level=error msg="command terminated with exit code 28"time="2020-06-10T16:47:06Z" level=info msg="output=[]"time="2020-06-10T16:47:06Z" level=info msg="stderr=[ERROR: [028]: backup and archive info files exist but do not match the database\n HINT: is this the correct stanza?\n HINT: did an error occur during stanza-upgrade?\n]"time="2020-06-10T16:47:06Z" level=error msg="command terminated with exit code 28"- Describe the issue:
I am having trouble understanding how one can restore in the following situation:
- Backups were saved to a remote S3 repo
- Postgres host and local backrest repo completely destroyed (whole machine crashed)
- I have a new machine with the same Postgres/pgbackrest version installed
- I would like to restore from S3 but the system-id on the new machine will always be different from the the one that was used to create the backups to S3, so create-stanza fails on the existing S3 bucket
I didn't find information in the Guide for this situation.
How do I create the stanza and restore to the new machine?