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). VPC Peering in not an option as Clickhouse doesn’t support it. Is there a good way to do that?
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
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
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.
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.