Re: In-order pg_dump (or in-order COPY TO) - Mailing list pgsql-general

From Dimitrios Apostolou
Subject Re: In-order pg_dump (or in-order COPY TO)
Date
Msg-id 2s558no0-705o-94r2-5s1q-npprn7508702@tzk.arg
Whole thread Raw
In response to Re: In-order pg_dump (or in-order COPY TO)  (Ron Johnson <ronljohnsonjr@gmail.com>)
List 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 by date:

Previous
From: Dimitrios Apostolou
Date:
Subject: Re: In-order pg_dump (or in-order COPY TO)
Next
From: Greg Sabino Mullane
Date:
Subject: Re: In-order pg_dump (or in-order COPY TO)