Migrate data from another Neon project won't work
following these instructions:
https://neon.tech/docs/import/migrate-from-neon
it recommends
pg_dump -Fc -v -d postgresql://[user]:[password]@[source_neon_hostname]/[dbname] | pg_restore -v -d postgresql://[user]:[password]@[destination_neon_hostname]/[dbname]
but only pg dump is executed then it finish, i'm trying to migrate the data of my neon db to a new region
thnak you
Neon
Migrate data from another Neon project - Neon Docs
This guide describes how to migrate a database from one Neon project to another by piping data from pg_dump to pg_restore. Avoid using pg_dump over a pooled connection string (see PgBouncer issues 452...
4 Replies
old-apricotOP•8mo ago
ok it worked, should i worry about the "owner" error?
robust-apricot•8mo ago
Nope, unless you have custom roles defined.
old-apricotOP•8mo ago
thx!
then I should have added no owner param right?
robust-apricot•8mo ago
yeah, but it's fine since you might have a project where you did define custom roles that you were looking to switch over.