pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dumpall size
2+ messages / 2 participants
[nested] [flat]
* pg_dumpall size
@ 2008-10-21 17:56 Marc Fromm <Marc.Fromm@wwu.edu>
0 siblings, 1 reply; 2+ messages in thread
From: Marc Fromm @ 2008-10-21 17:56 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_dumpall size
@ 2008-10-22 02:18 Scott Marlowe <scott.marlowe@gmail.com>
parent: Marc Fromm <Marc.Fromm@wwu.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2008-10-22 02:18 UTC (permalink / raw)
To: Marc Fromm <Marc.Fromm@wwu.edu>; +Cc: pgsql-admin
On Tue, Oct 21, 2008 at 11:56 AM, Marc Fromm <Marc.Fromm@wwu.edu> wrote:
> 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
Different default compression levels for gzip? try gzip -6 or
something on both of them.
Otherwise, unzip them and compare sizes to see if they really are the
same unzipped.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-10-22 02:18 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-10-21 17:56 pg_dumpall size Marc Fromm <Marc.Fromm@wwu.edu>
2008-10-22 02:18 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox