Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C88FE9FB477 for ; Mon, 12 Feb 2007 13:34:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 49404-07 for ; Mon, 12 Feb 2007 13:34:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 246549FB3E1 for ; Mon, 12 Feb 2007 13:34:41 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l1CHYeHu011101; Mon, 12 Feb 2007 12:34:40 -0500 (EST) To: Lewis Kapell cc: pgsql-admin@postgresql.org Subject: Re: dump sizes changed... In-reply-to: <45D095C2.7080701@setonhome.org> References: <45D095C2.7080701@setonhome.org> Comments: In-reply-to Lewis Kapell message dated "Mon, 12 Feb 2007 11:28:50 -0500" Date: Mon, 12 Feb 2007 12:34:40 -0500 Message-ID: <11100.1171301680@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.119 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/155 X-Sequence-Number: 24620 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