Configure a standby and primary for S3 WAL streaming

[morkalfon]

Which image of the operator are you using? ghcr.io/zalando/postgres-operator:v1.11.0
Where do you run it – cloud or metal? Kubernetes
Type of issue: Question

Hello, I have a few questions regarding the PostgreSQL Operator setup:

1. Could you provide an example or template demonstrating how to deploy a primary cluster with S3-based WAL archiving enabled, along with a standby cluster that uses it?

2. Does the standby cluster require a full cloning before it can start using WAL streaming? What is the correct procedure to initialize a standby cluster from scratch if it's using S3 bucket?

3. Is it possible to configure multiple standby clusters—one replicating via S3 WAL and another using direct TCP streaming replication?

4. In case of a standby promotion, is there a way to roll back the promotion, or is it an irreversible operation?

Appreciate your assistance with this!