Migrating Data from database on 1 neon account to another account
HI i am Abhay and
I recently created a new neon account and wanted to copy the whole database with data from my old account to my new account
i tried running
"pg_dump --no-owner --no-privileges --no-publications --no-subscriptions --no-tablespaces -Fc -v -d "<SOURCE CONNECTION STRING>" -f database.bak"
AND THEN I RAN
"pg_restore -v -d "< TARGET postgres connection string>" database.bak"
🥲🥲 Please help some one I am totally frustated the command is also running but data is not getting in my new account
2 Replies
national-gold•3mo ago
Hi, is your old Neon account blocked in any way due to exceeding usage limits?
national-gold•3mo ago
If you're not blocked due to usage, the Migration Assistant could be used in this scenario:
https://neon.com/docs/import/import-data-assistant
Neon
Import Data Assistant - Neon Docs
When you're ready to move your data to Neon, our Import Data Assistant can help you automatically copy your existing database to Neon. You only need to provide a connection string to get started. You ...