Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D53389FB9B8 for ; Tue, 24 Jul 2007 23:12:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 47606-04 for ; Tue, 24 Jul 2007 23:11:50 -0300 (ADT) X-Greylist: delayed 00:06:40.422998 by SQLgrey-1.7.5 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id CCFDC9FB919 for ; Tue, 24 Jul 2007 23:12:06 -0300 (ADT) Received: (qmail 22454 invoked from network); 25 Jul 2007 02:05:23 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;c61ae5d2919882f86f22673a4f0b1b75; Received: from unknown (HELO mail.weatherbeeta.com.au) (10.20.0.2) by 10.20.0.254 with SMTP; 25 Jul 2007 02:05:23 -0000 Received: (qmail 25297 invoked by uid 1166); 25 Jul 2007 12:05:09 +1000 Received: from 172.20.0.155 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.0.155):. Processed in 0.327592 secs); 25 Jul 2007 02:05:09 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.0.155):. Processed in 0.327592 secs Process 25279) Received: from it-phil.weatherbeeta.com.au (HELO wbaus090) (172.20.0.155) by mail.weatherbeeta.com.au with SMTP; 25 Jul 2007 12:05:08 +1000 From: "Phillip Smith" To: Subject: Data directory was initialized by PostgreSQL version 8.3 Date: Wed, 25 Jul 2007 12:05:20 +1000 Organization: Weatherbeeta Pty Ptd Message-ID: <00b701c7ce60$4136ef50$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 Importance: Normal X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1185329123.227-22449-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.02/0.08 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.264 tagged_above=0 required=5 tests=AWL=-0.492, BAYES_20=-0.74, MIME_QP_LONG_LINE=1.396, RDNS_DYNAMIC=0.1 X-Spam-Level: X-Archive-Number: 200707/266 X-Sequence-Number: 26247 Hi All, Just tried to recompile (what I thought!) was the same version of PG = that I already had running, to add in the AdminPack to stop pgAdmin complaining about it being missing. After recompiling from source, with the Admin Pack (did it on a devel = box first to make sure I was doing the right thing), I did the following: 1. Shutdown PostgreSQL 2. 'gmake install' the recompiled version (same -prefix =3D = /usr/local/pg-8.2) 3. Restart PostgreSQL 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! The latest version on the postgresql.org website is 8.2.4 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. I can initialize a new data directory and restore last nights backup, = but I'd rather not have to loose everything that's happened in the last 4 = hours. Any advice on what's going on? Cheers, ~p *******************Confidentiality and Privilege Notice******************* The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments THINK BEFORE YOU PRINT - Save paper if you don't really need to print this e-mail.