Restore from s3 in not working

[idanl21]

Im trying to Create PostgresCluster in my EKS using the Operator.
thats my YAML -

apiVersion: postgres-operator.crunchydata.com/v1beta1
kind: PostgresCluster
metadata:
  name: rhino
spec:
  image: registry.developers.crunchydata.com/crunchydata/crunchy-postgres:ubi8-14.7-0
  postgresVersion: 14
  dataSource:
    pgbackrest:
      stanza: db
      configuration:
      - secret:
          name: my-secret
      global:
        repo1-path: /backrestrepo/pgo-002-backrest-shared-repo/backup/db/20230420-104207F/
      repo:
        name: repo1
        s3:
          bucket: "pgo-prod-bck-002"
          endpoint: "s3.us-east-1.amazonaws.com"
          region: "us-east-1"
  instances:
    - dataVolumeClaimSpec:
        accessModes:
        - "ReadWriteOnce"
        resources:
          requests:
            storage: 50Gi
  backups:
    pgbackrest:
      image: registry.developers.crunchydata.com/crunchydata/crunchy-pgbackrest:ubi8-2.41-4
      repos:
      - name: repo1
        volume:
          volumeClaimSpec:
            accessModes:
            - "ReadWriteOnce"
            resources:
              requests:
                storage: 50Gi

Somehow im getting that error from the rhino-pgbackrest-restore-XXXX pod -

Defaulted container "pgbackrest-restore" out of: pgbackrest-restore, nss-wrapper-init (init)
+ pgbackrest restore --stanza=db --pg1-path=/pgdata/pg14 --repo=1 --delta --link-map=pg_wal=/pgdata/pg14_wal
ERROR: [037]: restore command requires option: repo1-s3-key

my-secret Secret -
Created with the command
kubectl create secret generic my-secret --from-file=my-secret.yaml
my-secret.yaml :

[global]
repo1-s3-key=XXXXXXXXXXXXXXXXXXX
repo1-s3-key-secret=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

how can i make sure that the restoration command is with repo1-s3-key parameter ?

[ValClarkson]

HI @idanl21

Thanks for submitting this issue, I think you may just have a formatting error in your my-secret.yaml file. From above you have
[global] repo1-s3-key=XXXXXXXXXXXXXXXXXXX repo1-s3-key-secret=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

and it should be:

[global]
repo1-s3-key=XXXXXXXXXXXXXXXXXXX
repo1-s3-key-secret=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Please reach back out if formatting of your my-secret.yaml file is not the issue.

[idanl21]

Hey @ValClarkson
Thanks for the answer, i dont think that is the reason (my real file is looking like that -
[global]
repo1-s3-key=XXXXXXXXXXXXXXXXXXX
repo1-s3-key-secret=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

(it's just a problem of indentation in the issue)
Tried now again, still same error
Do you have maybe another idea ?

[idanl21]

@ValClarkson ?

[idanl21]

Stil same status, any help here ?

[jmckulk]

Hi @idanl21,

In your repo1-path for the restore, you are providing the path to a backup (/backrestrepo/pgo-002-backrest-shared-repo/backup/db/20230420-104207F/) instead of the path to the repo directory. Please try updating the path to point at the backrest repo and let us know if that works. Based on the spec you provided, I think it would be something like this:

      global:
        repo1-path: /backrestrepo/pgo-002-backrest-shared-repo

[jmckulk]

If you are still running into any issues, please let us know. For now, we are closing out this ticket.