$ pg_dump --host=farawaysrvr -Fc $REMOTEDB > /local/disk/backups/$REMOTEDB.dump
Is the data compressed on the remote server (thus minimizing traffic on the wire), or locally? (I'd test this myself, but the company has really strict firewall rules in place.)
$ pg_dump --host=farawaysrvr -Fc -j4 $REMOTEDB > /local/disk/backups/$REMOTEDB.dump
Will parallel backups work if pg_dump is v9.6 and the remote system is v8.4? Thanks -- Angular momentum makes the world go 'round.
