We have a use case where we need to proxy the AWS RDS postgres instance on to a virtual machine on google cloud. From there we are attempting to set replication between the cloudsql postgres instance on GCP and RDS instance which is as mentioned proxied on to a specific port(for instance 6434) VM on GCP.
I have attempted to use pgBouncer for this use case but later figured out that it does not support replication connections. I was curious if I HA proxy supports proxying replication connections?
Please let me know your thoughts. Many thanks in advance.