Triggering backup from outside the pod

Please, answer some short questions which should help us to understand your problem / question better?

• Which image of the operator are you using? e.g. registry.opensource.zalan.do/acid/postgres-operator:v1.10.1
• Where do you run it - cloud or metal? Kubernetes or OpenShift? AKS
• Are you running Postgres Operator in production? yes
• Type of issue? Question

I am wondering is it possible to manage postgres backups outside the pods? I know there are scheduled backups that we use and work fine. But there cases where we would want to create a backup on demand, just for some safety reasons. Based on documentation we have exec'ed into the container and ran the backup command. It has done its job well. But we would love to avoid having to exec into the pods, especially in production. Ideally we could trigger it outside of the pod. If we made separate pod that did it then it would still kind of have to exec so that is not an option. I checked the UI and it also doesn't seem to support backups. Only doable option seemed to add a new sidecar that would act as an API that would just react to requests, which we would send from outside, and if request came in with correct token then it would make a backup. First of all, that is pretty hacky, secondly it might not even work as expected - not sure if sidecar can even run the same backup scripts and have the same and working result.

So I have a question to the community - have you faced a similar issue, is there already something available for this that we just missed, maybe you have some workaround or alternatives to this?

Start with the documentation for scheduled backups and the backup command currently run inside the pod, then review how the operator UI handles backup-related operations. Define the supported external trigger and its completion criteria, including whether it can provide the same result without exec access.