pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump with custom format without compression
4+ messages / 3 participants
[nested] [flat]
* pg_dump with custom format without compression
@ 2017-04-08 08:58 Thorsten Schöning <tschoening@am-soft.de>
0 siblings, 1 reply; 4+ messages in thread
From: Thorsten Schöning @ 2017-04-08 08:58 UTC (permalink / raw)
To: 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.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äftsführer: Andreas Muchow
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_dump with custom format without compression
@ 2017-04-08 10:22 Michael Heaney <mheaney@jcvi.org>
parent: Thorsten Schöning <tschoening@am-soft.de>
0 siblings, 1 reply; 4+ messages in thread
From: Michael Heaney @ 2017-04-08 10:22 UTC (permalink / raw)
To: pgsql-admin
On 4/8/2017 4:58 AM, Thorsten Schöning wrote:
> 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
>
Try setting the compression level. I myself use "--compress=1", which
gives me decent compression for very little cost in backup speed.
--
Michael Heaney
JCVI
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_dump with custom format without compression
@ 2017-04-08 11:31 Thorsten Schöning <tschoening@am-soft.de>
parent: Michael Heaney <mheaney@jcvi.org>
0 siblings, 1 reply; 4+ messages in thread
From: Thorsten Schöning @ 2017-04-08 11:31 UTC (permalink / raw)
To: pgsql-admin
Guten Tag Michael Heaney,
am Samstag, 8. April 2017 um 12:22 schrieben Sie:
> Try setting the compression level. I myself use "--compress=1", which
> gives me decent compression for very little cost in backup speed.
Thanks, I feel so stupid. :-) Scrolled so many times over the docs and
didn't recognize that.
Mit freundlichen Grüßen,
Thorsten Schöning
--
Thorsten Schöning 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äftsführer: Andreas Muchow
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_dump with custom format without compression
@ 2017-04-11 05:40 Steven Chang <stevenchang1213@gmail.com>
parent: Thorsten Schöning <tschoening@am-soft.de>
0 siblings, 0 replies; 4+ messages in thread
From: Steven Chang @ 2017-04-11 05:40 UTC (permalink / raw)
To: Thorsten Schöning <tschoening@am-soft.de>; +Cc: pgsql-admin
alternative :
t
tar
Output a tar-format archive suitable for input into
pg_restore.
The tar format is compatible with the directory format:
extracting a tar-format archive produces a valid
directory-format archive. However, the tar format does not
support compression. Also, when using tar format the relative
order of table data items cannot be changed during restore
example :
pg_dump -U postgres -h faiserver -F t -f aaa.tar -d warehouse_db
Actually, in my experience, compress would finish more quickly due to
much smaller disk consumption size under modern cpu model.
Steven4
2017-04-08 19:31 GMT+08:00 Thorsten Schöning <tschoening@am-soft.de>:
> Guten Tag Michael Heaney,
> am Samstag, 8. April 2017 um 12:22 schrieben Sie:
>
> > Try setting the compression level. I myself use "--compress=1", which
> > gives me decent compression for very little cost in backup speed.
>
> Thanks, I feel so stupid. :-) Scrolled so many times over the docs and
> didn't recognize that.
>
> Mit freundlichen Grüßen,
>
> Thorsten Schöning
>
> --
> Thorsten Schöning 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äftsführer: Andreas Muchow
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2017-04-11 05:40 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-04-08 08:58 pg_dump with custom format without compression Thorsten Schöning <tschoening@am-soft.de>
2017-04-08 10:22 ` Michael Heaney <mheaney@jcvi.org>
2017-04-08 11:31 ` Thorsten Schöning <tschoening@am-soft.de>
2017-04-11 05:40 ` Steven Chang <stevenchang1213@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox