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 5F40D528E7 for ; Sun, 5 Jun 2005 23:43:44 -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 43283-06 for ; Mon, 6 Jun 2005 02:43:39 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id AB5ED528DD for ; Sun, 5 Jun 2005 23:43:38 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j562hfd1006064; Sun, 5 Jun 2005 22:43:42 -0400 (EDT) To: patrick.brennan@bsdfirst.com Cc: pgsql-admin@postgresql.org Subject: Re: Upgrade Data from 7.x.x to 8.x.x In-reply-to: <429FF5ED.22885.21D22633@localhost> References: <429FF5ED.22885.21D22633@localhost> Comments: In-reply-to "Patrick Brennan" message dated "Fri, 03 Jun 2005 06:17:17 +1200" Date: Sun, 05 Jun 2005 22:43:41 -0400 Message-ID: <6063.1118025821@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/22 X-Sequence-Number: 17777 "Patrick Brennan" writes: > 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? Read the PG_VERSION file that appears at the top level. > Secondly, is there anyway to import this data into PostgreSQL 8.0 > without need to run a 7.x postmaster? No. You need to run a matching 7.x postmaster and do pg_dumpall. regards, tom lane