Unable to transfer data to new DB
Hi all,
I'm in the process of handing over a project to a client, part of which is the transfer of ownership of all infrastructure, SaaS etc accounts. Neon doesn't yet have the ability to transfer a DB or project between accounts (from what I can find), so I'm following this guide: https://neon.tech/docs/import/import-from-neon#important-considerations
The problem is connecting to the server times out every time. I thought it might have been a postgres version mismatch but I made sure everything is on the same version (15)
Any help or ideas appreciated
Neon
Import 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. Use these instructions to Import a database from a Neon project created in on...
4 Replies
extended-salmon•2y ago
Looks like you're trying to connect to port 5433. Neon uses 5432
xenial-blackOP•2y ago
Weird. I didn't specify a port nor did I think it was necessary, I just used the connection strings from the neon console as is
extended-salmon•2y ago
Maybe you have set a default of 5433 in
psqlrc (https://wiki.postgresql.org/wiki/Psqlrc) or PGPORT is set in your environment.dependent-tan•2y ago
Hi there, I just validated those instructions. Here's my exact command, which worked (actual user:password not included):
pg_dump -Fc -v -d postgres://user:password@ep-wispy-sun-a5q4sepa.us-east-2.aws.neon.tech/neondb | pg_restore -v -d postgres://user:password@ep-misty-surf-a4pit3gh.us-east-1.aws.neon.tech/neondb
I had a database named neondb on the source Neon project with data, and a database of the same same but empty on the target Neon project.
Hope this helps!