Hacker News new | ask | show | jobs
by y4mi 3886 days ago
and the default dumps are simple sql files, which you can actually pipe to another server.

pg_dump -C mydb | psql -h ${some_other_server} mydb