Before transferring the data. Compare the default settings and logging configuration.
-----Original Message----- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@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 <splu...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
