Migrating from Vercel Postgres to neon
I am currently using the Vercel Postgres integration and I wasn't fully aware of the technical limitations it has. I'm interested in moving to neon to have the full access to the console. Any suggestions on how best to do that?
4 Replies
correct-apricot•2y ago
Hi @praskOo Unfortunately, we do not have an an automated process for that. It requires exporting your data from Vercel postgres with pg_dump and importing it to your Neon database with pg_restore.
https://neon.tech/docs/import/import-from-postgres
If your database is on the smaller size, you can pipe that operation, which is a little easier:
https://neon.tech/docs/import/import-from-postgres#pipe-pgdump-to-pgrestore
Neon
Import data from Postgres - Neon Docs
This topic describes migrating data from another Postgres database to Neon using the pg_dump and pg_restore command line utilities. Avoid using pg_dump over a pooled connection string (see PgBouncer i...
correct-apricot•2y ago
Hey, I am here for the same reason. It's a shame Vercel still does not have backups and snapshots available after almost 1 year. Since it's just a wrapper on top of Neon, why can't we do that?
eager-peach•2y ago
We don't control what's possible from the Vercel side AFAIK. Might be worth asking them if they plan to expand the features on offer.
correct-apricot•2y ago
Thanks Evan. Already asked them months ago and all I got was a short answer, not available at the moment. It's very frustrating for us. From developer perspective I am guessing that's only a provider flag on your side but I can imagine how things work business side 🙂 Anyways, community is not happy with that integration and you guys should warn Vercel about it IMO 🙂