Re: A couple of pg_dump questions

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: A couple of pg_dump questions
Дата
Msg-id CALd+dcfKBAf7=ihA4v1GgnrkkOZvyBDOncK-WXZB-LsqUuQptQ@mail.gmail.com
обсуждение исходный текст
Ответ на A couple of pg_dump questions  (Ron <ronljohnsonjr@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Problem with trigger makes Detail record be invalid
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Problem with trigger makes Detail record be invalid