Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id C54F19FB632 for ; Mon, 12 Feb 2007 13:42:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 69226-06 for ; Mon, 12 Feb 2007 13:42:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.setonhome.org (mail.setonhome.org [65.213.207.11]) by postgresql.org (Postfix) with SMTP id C22FA9FB626 for ; Mon, 12 Feb 2007 13:42:50 -0400 (AST) Received: (qmail 78218 invoked from network); 12 Feb 2007 17:39:05 -0000 Received: from unknown (HELO ?65.213.207.9?) (65.213.207.9) by 0 with SMTP; 12 Feb 2007 17:39:05 -0000 Message-ID: <45D0A719.9030705@setonhome.org> Date: Mon, 12 Feb 2007 12:42:49 -0500 From: Lewis Kapell Organization: Seton Home Study School User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: dump sizes changed... References: <45D095C2.7080701@setonhome.org> <11100.1171301680@sss.pgh.pa.us> In-Reply-To: <11100.1171301680@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200702/156 X-Sequence-Number: 24621 Sorry, I should have given the versions. The old server was running 8.0.8, the new server is running 8.2.1. Thank you, Lewis Kapell Computer Operations Seton Home Study School Tom Lane wrote: > Lewis Kapell writes: >> We recently migrated to a new server after having had the old one >> running continously for over a year. The first night that we did a >> backup, the file produced by pg_dumpall was noticably smaller than the >> one we got from the old server prior to the switchover (2.5 GB versus >> 3.1 GB). > >> Is this something we should be alarmed about, > > It requires investigation at least. Are these the same PG version, or > different ones? > > We modified pg_dump awhile ago to be less verbose, but I think it was > only shortening the "comments" a bit; your result sounds too different > to be explained by that. > > regards, tom lane