Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C6B749FBBC6 for ; Tue, 24 Jul 2007 23:39:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 61196-04 for ; Tue, 24 Jul 2007 23:39:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 262109FBBB3 for ; Tue, 24 Jul 2007 23:39:30 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l6P2dSPf029551; Tue, 24 Jul 2007 22:39:28 -0400 (EDT) To: "Phillip Smith" cc: pgsql-admin@postgresql.org Subject: Re: Data directory was initialized by PostgreSQL version 8.3 In-reply-to: <00b701c7ce60$4136ef50$9b0014ac@wbaus090> References: <00b701c7ce60$4136ef50$9b0014ac@wbaus090> Comments: In-reply-to "Phillip Smith" message dated "Wed, 25 Jul 2007 12:05:20 +1000" Date: Tue, 24 Jul 2007 22:39:28 -0400 Message-ID: <29550.1185331168@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/269 X-Sequence-Number: 26250 "Phillip Smith" writes: > Now PostgreSQL complains at me with the following error: > 2007-07-25 11:52:05 EST @ []DETAIL: The data directory was initialized by > PostgreSQL version 8.3, which is not compatible with this version 8.2.4. > As far as I'm aware, 8.3 doesn't exist! You seem to have pulled a development snapshot from someplace ... > I'm assuming the problem is because the PG_VERSION file in the data > directory says 8.3, so I'm making a copy of the directory, changing that to > 8.2 and see if it will start with that. There is exactly 0 chance that that will work. The PG_VERSION test is there to save you from worse and more obscure failures involving incompatible system catalog layouts. regards, tom lane