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

• [x] Provide information about your environment (see below for more information).
• [x] Provide any steps or other relevant details related to your question.
• [x] Attach logs, where applicable. Please do not attach screenshots showing logs unless you are unable to copy and paste the log data.
• [x] 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.

[gkolvo]

Hi, Is there any news in which pgo version this feature will be included?