Transferring from cloud to self-host in Supabase

To migrate from cloud to self-hosting, you can use the pg_dump command to export your database to an SQL file, which then you can run on any database to load the same data in.

You can then try to import your SQL files using psql from the terminal:

psql -h 127.0.0.1 -p 5432 -d postgres -U postgres -f <dump-file-name>.sql

You can also find some useful information about self-hosting here: https://supabase.com/docs/guides/self-hosting.