how to configure pgbackrests in postgresclusters to use a remote sftp repository as repo2

[qduxiaoliang]

If you believe you have found have found a bug, please open up Bug Report

If you have a feature request, please open up a Feature Request

You can find information about general PGO support at:

https://access.crunchydata.com/documentation/postgres-operator/latest/support/

Questions

I am trying to deploy an instance of postgreclusters in private kubernetes cluster. I want to configure pgbackrest in postgreclusters to use a remote sftp repository as repo2, besides the repo1 created in the kubernetes cluster. the private kubernetes cluster can not reach gcs, s3, azure and so on. I want to backup postgres to a remote sftp host outside of kubernetes cluster.

I looked through the document in https://access.crunchydata.com/documentation/postgres-operator/5.7/references/crd/5.7.x/postgrescluster#postgresclusterspecbackupspgbackrest. however, I couldn't find a good solution. the repos in https://access.crunchydata.com/documentation/postgres-operator/5.7/references/crd/5.7.x/postgrescluster#postgresclusterspecbackupspgbackrestreposindex does not support sftp repo.

how to configure pgbackrest in postgreclusters to use a remote sftp repository as repo2, besides the repo1 created in kubernetes cluster?

For questions that are neither bugs nor feature requests, please be sure to

• Provide information about your environment (see below for more information).
• Provide any steps or other relevant details related to your question.
• Attach logs, where applicable. Please do not attach screenshots showing logs unless you are unable to copy and paste the log data.
• Ensure any code / output examples are properly formatted for legibility.

Besides Pod logs, logs may also be found in the /pgdata/pg<MAJOR_VERSION>/log directory on your Postgres instance.

If you are looking for general support, please view the support page for where you can ask questions.

Environment

Please provide the following details:

• Platform: (Kubernetes, OpenShift, Rancher, GKE, EKS, AKS etc.)
  Kubernetes

• Platform Version: (e.g. 1.20.3, 4.7.0)
  v1.30.13

• PGO Image Tag: (e.g. ubi8-5.x.y-0)
  ubi8-5.7.4-0

• Postgres Version (e.g. 15)
  15

• Storage: (e.g. hostpath, nfs, or the name of your storage class)
  longhorn

[andrewlecuyer]

@qduxiaoliang thanks for reaching out! I'm going to flag this as a feature request, since SFTP support has not yet been added to PGO.