X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EAB8D5288E for ; Thu, 2 Jun 2005 15:17:18 -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 78723-02 for ; Thu, 2 Jun 2005 18:17:17 +0000 (GMT) Received: from avmta4-rme.xtra.co.nz (avmta4-rme.xtra.co.nz [210.86.15.159]) by svr1.postgresql.org (Postfix) with ESMTP id 87C7952872 for ; Thu, 2 Jun 2005 15:17:13 -0300 (ADT) Received: from pop2-rme.xtra.co.nz ([210.86.15.240]) by avmta4-rme.xtra.co.nz with ESMTP id <20050602181718.MAMA2892.avmta4-rme.xtra.co.nz@pop2-rme.xtra.co.nz> for ; Fri, 3 Jun 2005 06:17:18 +1200 Received: from big ([219.88.156.213]) by pop2-rme.xtra.co.nz with ESMTP id <20050602181717.UAKM16943.pop2-rme.xtra.co.nz@big> for ; Fri, 3 Jun 2005 06:17:17 +1200 From: "Patrick Brennan" To: pgsql-admin@postgresql.org Date: Fri, 03 Jun 2005 06:17:17 +1200 Subject: Upgrade Data from 7.x.x to 8.x.x Reply-To: patrick.brennan@bsdfirst.com Message-ID: <429FF5ED.22885.21D22633@localhost> X-mailer: Pegasus Mail for Windows (4.21c) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/20 X-Sequence-Number: 17775 Hi there, Hopefully a simple question. I have a copy of the data from an old PostgreSQL installation (it's not a dump, it's a copy of the PGDATA directory). I have two questions, is there a simple way for me to determine the version of PostgreSQL that this data belongs to? Secondly, is there anyway to import this data into PostgreSQL 8.0 without need to run a 7.x postmaster? Any suggestions would be greatly appreciated. Regards, Patrick B.T.W. For those curious, this data came from a RAID5 array in which two disks had failed. I spent a week messing with pyflag before I managed to recover this data.