Skip site navigation (1) Skip section navigation (2)

pg_dumpall size

From: Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dumpall size
Date: 2008-10-21 17:56:56
Message-ID: B0D7C0A3F35FE144A70312D086CBCA9B020A8229CC@ExchMailbox2.univ.dir.wwu.edu (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-admin by date

Next:From: Brad NicholsonDate: 2008-10-21 17:58:11
Subject: Re: oid2name
Previous:From: Isabella GhiureaDate: 2008-10-21 17:45:09
Subject: oid2name

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group