N
Neon•2y ago
ambitious-aqua

Migrating from Supabase

Hey guys! Love Neon. I am just trying to migrate from Supabase to Neon, as I have an issue with max connections in serverless and high-scale environments which Neon is perfect for. I am trying to migrate my database, however my database in Supabase is called postgres, which is protected in Neon. Any possible solutions? Thanks!
1 Reply
adverse-sapphire
adverse-sapphire•2y ago
Hey, it's great to hear that Neon is a fit for you 🙂 How are you trying to migrate? Can you pg_dump your database from Supabase, then use psql to add it to Neon? Something like: 
# Dump from supabase
pg_dump $SUPABASE_CONNECTION_STRING/postgres > dump.sql

# Create database named dbname (or whatever you choose in Neon) using SQL Editor or psql

# Restore the db to Neon
psql $NEON_CONNECTION_STRING/dbname < dump.sql
# Dump from supabase
pg_dump $SUPABASE_CONNECTION_STRING/postgres > dump.sql

# Create database named dbname (or whatever you choose in Neon) using SQL Editor or psql

# Restore the db to Neon
psql $NEON_CONNECTION_STRING/dbname < dump.sql

Did you find this page helpful?