Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id E5F5D9FB5E1 for ; Mon, 12 Feb 2007 12:35:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 81567-07 for ; Mon, 12 Feb 2007 12:35:33 -0400 (AST) X-Greylist: delayed 00:06:41.553223 by SQLgrey-1.7.4 Received: from mail.setonhome.org (mail.setonhome.org [65.213.207.11]) by postgresql.org (Postfix) with SMTP id C82089FB588 for ; Mon, 12 Feb 2007 12:35:33 -0400 (AST) Received: (qmail 69838 invoked from network); 12 Feb 2007 16:25:07 -0000 Received: from unknown (HELO ?65.213.207.9?) (65.213.207.9) by 0 with SMTP; 12 Feb 2007 16:25:07 -0000 Message-ID: <45D095C2.7080701@setonhome.org> Date: Mon, 12 Feb 2007 11:28:50 -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: dump sizes changed... 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/154 X-Sequence-Number: 24619 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, or could this be the normal result of dumping and reloading a large database? Thanks for any who can advise. -- Thank you, Lewis Kapell Computer Operations Seton Home Study School