Skip to content
Home / Migrations / Self-hosted PostgreSQL → Neon

Self-hosted PostgreSQL → Neon

easy

Neon adds branching, autoscaling, scale-to-zero, and managed backups. Zero config for the features you'd spend weeks building on self-hosted.

Estimated: 1-3h · 5 steps
Progress0%
Step 1: Create Neon project

Sign up at neon.tech. Get your connection string from the dashboard.

Step 2: Dump existing database
pg_dump -h localhost -U postgres mydb > mydb.sql
Step 3: Restore to Neon
psql $NEON_CONNECTION_STRING < mydb.sql
Step 4: Update connection string

Replace localhost Postgres URL with Neon connection string in your app and CI.

DATABASE_URL=postgres://user:pass@ep-xyz.neon.tech/mydb?sslmode=require
Step 5: Enable connection pooling

Use Neon's pooler URL for serverless environments to avoid connection limit issues.

✓ App connects. All queries work. pgvector extensions re-enabled if needed.
Get started with Neon →