heroku to supabase migration

I'm trying to follow the instructions on this github readme

https://github.com/supabase-community/heroku-to-supabase

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 failed
connection 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
GitHub
Heroku to Supabase Migration Guide. Contribute to supabase-community/heroku-to-supabase development by creating an account on GitHub.
Was this page helpful?