Database Connection Refused

ISSUE

We’d like to initialize our database; however we’re unable to connect to it despite setting its access to public.

Similar issue was raised here

HOW TO REPRODUCE

Hi @tawihealth ,

Can you please provide more details about the database that you’ve spin up with Qovery? Is it a managed or container version of Postgres? Are you using a cluster type EKS or EC2?

Romaric

This is a Container version of PG for our staging environment.

We deployed on EC2(K3S)

You might find this thread interesting for your issue.

For future reader:

I fixed this by SSH’ing into DB and running the SQL commands; you need the Qovery CLI.
Once logged in,

  • Remember in its current state your DBs are not publicly reachable, so point your apps to the internal host url.