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?
pgsql-admin by date
|Next:||From: Brad Nicholson||Date: 2008-10-21 17:58:11|
|Subject: Re: oid2name|
|Previous:||From: Isabella Ghiurea||Date: 2008-10-21 17:45:09|
|Subject: oid2name |