On Mon, Apr 16, 2018 at 6:58 PM, Ron <ronljohnsonjr@xxxxxxxxx> wrote:
We're upgrading from v8.4 to 9.6 on a new VM in a different DC. The dump file will be more than 1TB, and there's not enough disk space on the current system for the dump file.
Thus, how can I send the pg_dump file directly to the new server while the pg_dump command is running? NFS is one method, but are there others (netcat, rsync)? Since it's within the same company, encryption is not required.
Can you run pg_dump on the new server, connecting remotely to the current one?
--
--
Mike Nolan