Re: pg_dumpall size - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: pg_dumpall size
Date
Msg-id dcc563d10810211918h42f47e25ubdec690bbe83262d@mail.gmail.com
Whole thread Raw
In response to pg_dumpall size  (Marc Fromm <Marc.Fromm@wwu.edu>)
List 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.

pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: PITR question with base backup
Next
From: "Scott Whitney"
Date:
Subject: Another PITR question