We are running postgres from percona (pgdb) in beta environment inside kubernetes cluster with backups configured to cloud s3 service. Trying to restore the backup in dev environment which is based on docker compose.
The backup retrieval using a pgbackrest image is successful and written on a volume. The volume is later mounted to a database container (postgres).
ISSUE:
While trying running the backup restore and database, it tries to use pgbackrest while the restore process.
Using official postgres image we are getting error : pgbackrest command not found as official image does not ship with pgbackrest.
Using percona image perconalab/percona-distribution-postgresql:16, the same error that there is no pgbackrest available
Using percona image percona/percona-postgresql-operator:2.5.0-ppg16.4-postgres, it does not even run, keeps waiting for some sort of signal or maybe for operator and there is patroni command. This is the image we are using in our beta environment.
Need urgent help!
Hey Kushal,
Welcome to the Percona Community, and thank you for sharing the issue.
Please check with the latest images on perconalab/percona-distribution-postgresql:16.10. Earlier versions of ppg16 Docker images don’t include pgbackrest. These same images will also be released in the official Percona Docker repo in this month’s upcoming release.
Please don’t hesitate to reach out again if you have more questions.
Cheers,
It asks for pgbackrest conf, we have downloaded the data using pgbackrest, why it asks for that ?
pgBackRest’s configuration file (pgbackrest.conf) is not strictly mandatory but recommended. You can run the pgBackRest commands entirely with the command-line options. By default, pgBackRest looks at /etc/pgbackrest/pgbackrest.conf or /etc/pgbackrest.conf for this config file.
You can find more details about pgBackRest configurations at pgBackRest - User Guides .
I hope it helps.
Cheers,
Thanks, it worked, i used the command for resetting wal , i didn’t require wal log replay, thanks!
2 Likes