Is the managed cluster on DO can connect with Managed Database PostgreSQL database cluster by default ?
I try to create a deployment to create a pod that will need a database to interact with.
I configured a service with endpoints in the cluster to allow my pod to connect to Managed Database cluster in DO. When the pod created.It show error logs:
failed to open connection to database: pq: no pg_hba.conf entry for host "x.x.x.x", user "doadmin", database "testdb", SSL off\n"
As I guess that database cluster need to have a config to allow x.x.x.x (which I think it’s K8s cluster’s IP in DO).
Is there any confirmation that we don’t need additional setting on our K8s on DO and Managed Database PostgreSQL to allow those 2 can interact with each other as those was created with the same DO account.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.