But when I run the pg_dump I'm getting the following error:
pg_dump: error: connection to server at "ec2-54-224-120-186.compute-1.amazonaws.com" (54.224.120.186), port 5432 failed: SSL error: certificate verify failedconnection to server at "ec2-54-224-120-186.compute-1.amazonaws.com" (54.224.120.186), port 5432 failed: FATAL: no pg_hba.conf entry for host "152.171.245.125", user "myuser", database "mydb", SSL off
pg_dump: error: connection to server at "ec2-54-224-120-186.compute-1.amazonaws.com" (54.224.120.186), port 5432 failed: SSL error: certificate verify failedconnection to server at "ec2-54-224-120-186.compute-1.amazonaws.com" (54.224.120.186), port 5432 failed: FATAL: no pg_hba.conf entry for host "152.171.245.125", user "myuser", database "mydb", SSL off
I'm wondering how to force SSL and how to get the cert for that matter, I don't know where on heroku that's supposed to be, thank you so much
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.