A couple of pg_dump questions - Mailing list pgsql-general

From Ron
Subject A couple of pg_dump questions
Date
Msg-id e1f55676-d727-8be2-f4ec-61af2f2cc67e@gmail.com
Whole thread Raw
Responses Re: A couple of pg_dump questions  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: A couple of pg_dump questions  (Vick Khera <vivek@khera.org>)
List 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.


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Inconsistent compilation error
Next
From: "David G. Johnston"
Date:
Subject: Re: A couple of pg_dump questions