| From: | Thorsten Schöning <tschoening(at)am-soft(dot)de> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | pg_dump with custom format without compression |
| Date: | 2017-04-08 08:58:02 |
| Message-ID: | 329300973.20170408105802@am-soft.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi all,
I'm using pg_dump with custom format "c" on some databases containing
already compressed large binaries, like Zip, compressed PDF etc. So I
don't benefit of the compression of format "c" much, but creating a
dump takes about twice as much time compared to uncompressed format
"t".
Is there any way to use format "c" without any compression, so I get
somewhat the same processing time like with format "t"?
From the docs it sounds that format "c" is the most flexible when it
comes to restore and I would simply like to keep all the options it
provides, just in case. So if not compression is only possible with
"t", I might as well decide to use that and live with its theoretical
shortcomings on restore.
Thanks!
Mit freundlichen Grüßen,
Thorsten Schöning
--
Thorsten Schöning E-Mail: Thorsten(dot)Schoening(at)AM-SoFT(dot)de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/
Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04
AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Heaney | 2017-04-08 10:22:38 | Re: pg_dump with custom format without compression |
| Previous Message | Keith | 2017-04-08 00:05:31 | Re: Repeating autovacuum |