migrating from supabase

hey there. i'm trying to migrate from supabase right now. i'm trying to go the route of CDC and moving writes from supabase -> neon. the issue is that i can't create the replication slot correctly the issue that i run into is the fact that neon can't connect to supabase. i know it is possible - i use Sequin as CDC (which uses replication and everything). the issue is that when creating the subscription, neon throws the following error:

Query 1 ERROR at Line 1: : ERROR:  could not connect to the publisher: connection to server at "db.xxxx.supabase.co" (xx.xx.xx.xx), port 5432 failed: Connection refused
    Is the server running on that host and accepting TCP/IP connections?

Query 1 ERROR at Line 1: : ERROR:  could not connect to the publisher: connection to server at "db.xxxx.supabase.co" (xx.xx.xx.xx), port 5432 failed: Connection refused
    Is the server running on that host and accepting TCP/IP connections?

i'm going along with the supabase docs directly: https://supabase.com/docs/guides/database/postgres/setup-replication-external

3 Replies

manual-pinkOP•6mo ago

like the replication now has just stopped i think? the database size is not increasing - it's 16mb, been like that for a while. i have this in my PIDs, sometimes the logical replication worker is on but most of the time it's not there. what does this mean?

ambitious-aqua•6mo ago

Can you please try following this guide for migrating via logical replication https://neon.tech/docs/guides/logical-replication-supabase-to-neon Alternatively, you can dump and restore: https://neon.tech/docs/import/migrate-from-supabase

passive-yellow•6mo ago

You may also refer to https://discord.com/channels/1176467419317940276/1344628737680871516/1344995920592244756.

Gaming

Programming

migrating from supabase

Did you find this page helpful?