Proxy for Postgres replication connections

From: "Gone, Sajan" <SGone(at)victoria(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Proxy for Postgres replication connections
Date: 2023-09-06 13:49:44
Message-ID: DS0PR15MB565111B16784DC6779C48CB6D8EFA@DS0PR15MB5651.namprd15.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Good morning all,

We currently are working on migrating few postgres databases from AWS RDS to GCP CloudSQL. For that we have a use case where we need to use some kind of proxy like pgbouncer, HA Proxy or pgpool to proxy the RDS connections on to a VM hosted on GCP. Then we will initiate the postgres logical replication via the proxy tunnel from the CloudSQL instance (target) on to the RDS instance (Source). Even before someone calls it out, I admit that this is not an ideal way of doing things but because of some networking and security concerns we landed on this approach.

Does anyone know if any of the open source proxy tools which are commonly used for postgres support replication connections? I have attempted to use pgbouncer but unfortunately the current version of pgbouncer does not support postgres replication connections.

Many thanks in advance. Thank you!

Thanks,
Sajan Gone

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar 2023-09-06 22:43:16 Archive cleanup using pgbackrest
Previous Message Erik Wienhold 2023-09-06 09:50:42 Re: DBLINK Error