X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7BCC9D9001 for ; Thu, 15 Sep 2005 16:12:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16806-03 for ; Thu, 15 Sep 2005 19:12:47 +0000 (GMT) Received: from Annihilator00.marc.usda.gov (Annihilator01.marc.usda.gov [199.133.160.2]) by svr1.postgresql.org (Postfix) with ESMTP id A1C71D8FBF for ; Thu, 15 Sep 2005 16:12:46 -0300 (ADT) Received: from (199.133.160.2) by DA32USMOKC1_AVS01.usda.gov via smtp id 3130_1dddab24_2624_11da_8ea6_001143d22ff1; Thu, 15 Sep 2005 21:05:53 +0100 Received: from Email.marc.usda.gov by Annihilator00.marc.usda.gov via smtpd (for svr1.postgresql.org [200.46.204.71]) with ESMTP; Thu, 15 Sep 2005 14:12:48 -0500 Received: from snelling-nc6k.marc.usda.gov (10.1.9.40) by email.marc.usda.gov with ESMTP (Eudora Internet Mail Server 3.1.6) for ; Thu, 15 Sep 2005 14:12:46 -0500 Subject: 7.4 <-> 8.0 From: Warren Snelling Reply-To: snelling@email.marc.usda.gov To: pgsql-admin@postgresql.org Content-Type: text/plain Organization: Molecular Genetics Research Unit Date: Thu, 15 Sep 2005 14:10:04 -0500 Message-Id: <1126811405.12350.29.camel@localhost> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/175 X-Sequence-Number: 18912 All, Couple questions from to a recent upgrade from 7.4.8 to 8.0.3. With servers for both versions running on the same machine, pg_dumpall -p 5432 -c | psql -p 5433 template1 appears to have migrated the databases smoothly. At least I didn't notice any errors in the process, and all the data appears to be there. The one troubling thing is the new 8.0 databases take about half the disk space as the 7.4 databases. Similar dump | psql to recreate the databases on other machines running 7.4.7 and 7.4.8 show the same thing - the fresh copies take half the space of the old. What might be happening with the old db, so it takes so much more space? Could half the data be missing? What's the best way to move data from 8.0 to 7.4? The 8.0 pg_dump writes a dump that doesn't restore with 7.4 psql, and 7.4 pg_dump doesn't seem to handle an 8.0 database. At least I haven't found the right switches... Thanks, warren