postgres-operator icon indicating copy to clipboard operation
postgres-operator copied to clipboard

Change backup path s3

Open mrszop opened this issue 4 years ago • 2 comments

Hello,

is there a way to change to backup path to s3? Currently I'm getting always a backup created like s3://$s3-bucket-name/spilo/. I'd like to have something like this: s3://$s3-bucket-name/szop/. My config looks like this:

---
configAwsOrGcp:
  aws_region: "eu-central-1"
  aws_endpoint: "https://s3.eu-central-1.amazonaws.com"
  wal_s3_bucket: "$s3-bucket-name"

configLogicalBackup:
  logical_backup_provider: "s3"
  logical_backup_s3_access_key_id: "ACCESS_KEY_ID"
  logical_backup_s3_secret_access_key: "SECRET_KEY"
  logical_backup_s3_bucket: "$s3-bucket-name"
  logical_backup_s3_region: "eu-central-1"
  logical_backup_s3_endpoint: "https://s3.eu-central-1.amazonaws.com"
  logical_backup_schedule: "00 05 * * *"

Any chance to set a specific path?

Cheers

mrszop avatar Aug 20 '21 14:08 mrszop

Have a look at Spilo's list of environment variables that can be set with an extra pod_environment_configmap. I think prefix can be changed with this.

FxKu avatar Aug 24 '21 08:08 FxKu

The logical backup path appears to be hard coded to /spilo

https://github.com/zalando/postgres-operator/blob/6d0117b662bc2fd7880352b58258792ff2941d0a/docker/logical-backup/dump.sh#L100

Perhaps it can be at least somewhat configurable by setting logical_backup_s3_bucket_scope_suffix?

I think this should be configurable though, as I want to put these backups in a different path on an existing backup bucket.

NickLarsenNZ avatar Jun 22 '22 10:06 NickLarsenNZ