Re: In-order pg_dump (or in-order COPY TO)

Поиск
Список
Период
Сортировка
От Dimitrios Apostolou
Тема Re: In-order pg_dump (or in-order COPY TO)
Дата
Msg-id 2s558no0-705o-94r2-5s1q-npprn7508702@tzk.arg
обсуждение исходный текст
Ответ на Re: In-order pg_dump (or in-order COPY TO)  (Ron Johnson <ronljohnsonjr@gmail.com>)
Список pgsql-general
On Wednesday 2025-08-27 00:00, Ron Johnson wrote:
>
>This might be a silly question, but why are you using -Fc to create multi-TB dumps instead of -Fd?  If nothing else,
theparallelization granted by -Fd will greatly speed up the dumps. 

Hi Ron,

the primary reason is space. With -Fc I don't have to store the 10TB
archive locally. And I don't have to wait for pg_dump to finish. I pipe
it directly to the "borg create" command which does compression and
deduplication and sends new chunks to a remote borgbackup server.

Regards,
Dimitris



P.S. please use "Reply-all" when replying, I've missed quite a few
      replies that I found on the list archives. :-)

В списке pgsql-general по дате отправления: