| From: | Dimitrios Apostolou <jimis(at)gmx(dot)net> |
|---|---|
| To: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: In-order pg_dump (or in-order COPY TO) |
| Date: | 2025-08-27 12:52:39 |
| Message-ID: | 2s558no0-705o-94r2-5s1q-npprn7508702@tzk.arg |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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, the parallelization 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. :-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2025-08-27 14:06:40 | Re: In-order pg_dump (or in-order COPY TO) |
| Previous Message | Dimitrios Apostolou | 2025-08-27 12:40:57 | Re: In-order pg_dump (or in-order COPY TO) |