N
Neon•2y ago
flat-fuchsia

How to migrate data from Neon db?

Hi team, I started using neon db a month back but I was not happy by the services I want to migrate db data Please help me out here
3 Replies
noble-gold
noble-gold•2y ago
why not just use the pg_dump command? something like 
PGPASSWORD=<password> pg_dump -C -h <host> -U <user> <database_name> | psql -h <new_host> -U <new_user> <new_database_name>
PGPASSWORD=<password> pg_dump -C -h <host> -U <user> <database_name> | psql -h <new_host> -U <new_user> <new_database_name>
just make sure <new_database_name> is same as <database_name>, otherwise it fails last i checked
rising-crimson
rising-crimson•2y ago
That's correct. IF this helps, we have a guide which describes this process in details: https://neon.tech/docs/import/import-from-postgres You can follow this process to dump and reload your data with another provider. This being said, I'm truly sorry to read that you're unhappy with our services. I would really appreciate if you could drop me a DM explaining for which reasons you're unhappy with our services. Did you face any difficulties using our product? Did you encountered errors? We take the feedback of our customers very seriously as this helps us to identify where should we improve. Thank you in advance
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 Neon connection (see PgBouncer iss...
flat-fuchsia
flat-fuchsiaOP•2y ago
Thank you I will give it a try Dropped my feedback @Yanic for your reference

Did you find this page helpful?