Re: 9.4 -> 9.5 dump size reduction

Before transferring the data.

Compare the default settings and logging configuration.




-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom Lane
Sent: 12 February 2016 04:49
To: Seb
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 9.4 -> 9.5 dump size reduction

Seb <spluque@gmail.com> writes:
> I recently upgraded a server from 9.4 to 9.5 (Debian) via
> pg_upgradecluster.  The upgrade finished well, and so far the
> databases in the upgraded cluster seem in good form.  However, I
> noticed a dramatic reduction in the size of the dump created by the new
server.
> One of the databases was 34G when dumped by the 9.4 server is now
> dumped at 1.1G in the new 9.5 version (using pg_dump -Fc in both
> cases).  What has caused such remarkable improvement?!

That seems really fishy.  Better check to see if all your data is still
there :-(

            regards, tom lane


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general