Date: Sat, 8 Apr 2017 10:58:02 +0200
From: =?utf-8?Q?Thorsten_Sch=C3=B6ning?= <tschoening@am-soft.de>
Organization: AM-SoFT IT-Systeme
Message-ID: <329300973.20170408105802@am-soft.de>
To: pgsql-admin@postgresql.org
Subject: pg_dump with custom format without compression
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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"?

=46rom 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=C3=BC=C3=9Fen,

Thorsten Sch=C3=B6ning

--=20
Thorsten Sch=C3=B6ning       E-Mail: Thorsten.Schoening@AM-SoFT.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=C3=A4ftsf=C3=BChrer: Andreas Muchow


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin