Hi, I saw a some related posts from few years ago, but wanted to check what are recent updates on this topic. So, we have Cloud Managed Postgres instance in Qovery and want to make it accessible to Clickhouse Cloud without making it publicly accessible to everyone (basically - to do IP whitelisting)…

Hello @km1414 , You can configure that in the advance settings of your cluster [image] Be sure to re-deploy the cluster after you made the chance.

Hi, we are facing the same need. Could we have an answer/advice on this one? Thanks!

Hello @km1414 Have you tried a private network like VPN? If not, try this. It can make a good connection between the postgres instance and clickhouse cloud; and Also you can try to use a reverse proxy set up :with IP white listing to restrict access IP addresses. Let me know if this works

Thanks for your advice. We decided to choose another way here and periodically send this data to Clickhouse instead of connecting from CH to postgres.

Cloud Managed DB (AWS RDS) IP whitelisting

Questions and Answers

Erebe (Romain Gerard) June 12, 2024, 11:09am 4

Hello @km1414 ,

You can configure that in the advance settings of your cluster

Be sure to re-deploy the cluster after you made the chance.

1 Like

Topic		Replies	Views
Access private databases from specific IPs Questions and Answers aws	2	420	March 25, 2024
Whitelist IPs for AWS RDS Postgresql DB Deployment qovery , aws	4	913	March 25, 2024
Database.postgresql.deny_public_access Cluster Setting Questions and Answers aws	5	464	March 25, 2024
Applications on different AWS clusters using the same PostgreSQL database Deployment	4	836	March 25, 2024
Whitelist Qovery apps for AWS RDS Questions and Answers	2	368	March 25, 2024

Cloud Managed DB (AWS RDS) IP whitelisting

Related topics