Re: A couple of pg_dump questions - Mailing list pgsql-general

From Vick Khera
Subject Re: A couple of pg_dump questions
Date
Msg-id CALd+dcfKBAf7=ihA4v1GgnrkkOZvyBDOncK-WXZB-LsqUuQptQ@mail.gmail.com
Whole thread Raw
In response to A couple of pg_dump questions  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
On Thu, Apr 19, 2018 at 6:39 PM, Ron <ronljohnsonjr@gmail.com> wrote:

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


The compression is done locally. If your network is slower than compression, then you could tunnel it through an SSH connection with compression enabled.

As for your parallel dump, you cannot do that to stdout and "c" format. You have to tell pg_dump the directory name to write, as that is the only format that supports parallel dumps. 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Problem with trigger makes Detail record be invalid
Next
From: Adrian Klaver
Date:
Subject: Re: Problem with trigger makes Detail record be invalid