Re: pg_dump with custom format without compression

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(at)am-soft(dot)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(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
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>