Is it possible to directly transfer a PostgreSQL database between two PostgreSQL servers?
I've currently been setting up a "development" version of my production database by using pg_dump to serialize the entire database to a file, download the file, and then using pg_restore to load the database onto the development server. However, as the database has been growing, this process is now taking hours. Is there anyway to simply "connect" the two servers and transfer the database directly, instead of this lengthy dump/download/restore process?