My input (source) DB is 1TB in size, using the options as stated in my original email (i.e. no compression it would seem) the output file size is "only" 324GB. I presume all of the formatting/indices have been ommited. As I said before, I can browse the backup file with less/heat/cat/tail etc.
Regards,
Henk
On Tue, Jul 5, 2016 at 4:54 PM, J. Cassidy <sean@jdcassidy.eu> wrote: > I have hopefully an "easy" question. > If I issue the pg_dump command with no switches or options i.e. > /usr/local/pgsql/bin/pg_dump -v dbabcd > /data3TB/Backup/dbabcd > Is their any "default" compression involved or not? Does pg_dump talk to > zlib during the dump process given that I have not specified any compression > on the > command line? (see above).
IIRC no options means you are requesting an SQL-script. Those are not compressed, just pipe them through your favorite compressor. ( In a later message you stated you were in Linux and had a 324Gb file, and could head/tail it, have you done so? ).
> Your considered opinions would be much appreciated.
OTOH, with those big backup I would recommend using custom format ( -Fc ), it's much more flexible ( andyou can have the sql script but asking pg_restore to generate it if you need it, but not the other way round ).
Francisco Olarte.
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general