Transfer data from Heroku Postgres to Supabase

[ShubhamVerma1811]

Hey, I looked for this question but couldn't find.
I have a Postgres DB hosted on Heroku and it has data, is there a way to export that data and import it in Supabase?

[kiwicopple]

Definitely the easiest way is to use pg_dump (from Heroku) and then pg_restore into your Supabase database

https://www.postgresql.org/docs/current/app-pgdump.html

For better performance, it is probably useful to turn off all replication/realtime before you do this:

begin; 
  -- remove the realtime publication
  drop publication if exists supabase_realtime; 

  -- re-create the publication but don't enable it for any tables
  create publication supabase_realtime;  
commit;

[flov]

How can I pg_restore into the supabase database?