A couple of pg_dump questions

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: A couple of pg_dump questions
Date: 2018-04-19 22:39:27
Message-ID: e1f55676-d727-8be2-f4ec-61af2f2cc67e@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


$ 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-04-19 22:48:35 Re: A couple of pg_dump questions
Previous Message Melvin Davidson 2018-04-19 20:20:50 Re: Inconsistent compilation error