2024
I always try to transfer database from account to account, but Neon still not yet support it. So I have to do it manually.
pg_dump "postgresql://user:password@serveroftheneonpostgres/talktodevdbname?sslmode=require" -F c -b -v -f database.dumppg_restore -v -d postgresql://user:password@serveroftheneonpostgres/talktodevdbname?sslmode=require database.dump
Note: If the output file is .sql then use psql
psql 'postgresql://user:password@serveroftheneonpostgres/talktodevdbname?sslmode=require' < database.sql*YAGNI. Only implement things when you actually need them, never when you foresee that you’ll need them. The cost isn’t just in implementation, but also in all future maintenance. As Fried said, “you should only consider features if they’re willing to stand on the porch for three days waiting to be let in.” Please note that this is a rule of thumb and there are contextual counterpoints.