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@xxxxxxxxxx>:
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@xxxxxxxxxx
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
