pg_dumpall size - Mailing list pgsql-admin

From Marc Fromm
Subject pg_dumpall size
Date
Msg-id B0D7C0A3F35FE144A70312D086CBCA9B020A8229CC@ExchMailbox2.univ.dir.wwu.edu
Whole thread Raw
Responses Re: pg_dumpall size  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-admin

I have the same postgresql databases on two different servers.

Boteh servers have the same version of postgresql, 8.1.

The following backup command creates a file twice as big on one server, compared to the other server.

pg_dumpall -c -U postgres | gzip > alldb.gz

 

Red Hat 5EL: alldb.gz is 29MB

Fedora Core 5: alldb.gz is only 15MB

 

Any ideas as to why the red hat box pg_dumpall file is about twice the size?

 

Marc

 

pgsql-admin by date:

Previous
From: Isabella Ghiurea
Date:
Subject: oid2name
Next
From: Brad Nicholson
Date:
Subject: Re: oid2name