| From: | "FarjadFarid\(ChkNet\)" <farjad(dot)farid(at)checknetworks(dot)com> |
|---|---|
| To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Seb'" <spluque(at)gmail(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 9.4 -> 9.5 dump size reduction |
| Date: | 2016-02-12 14:06:54 |
| Message-ID: | 001f01d1659e$a0b17e80$e2147b80$@checknetworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Before transferring the data.
Compare the default settings and logging configuration.
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: 12 February 2016 04:49
To: Seb
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 9.4 -> 9.5 dump size reduction
Seb <spluque(at)gmail(dot)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(at)postgresql(dot)org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2016-02-12 14:28:52 | Re: database corruption |
| Previous Message | Lesley Kimmel | 2016-02-12 13:20:37 | Re: PosgreSQL Security Architecture |