Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id F1181632DD7 for ; Sat, 17 Jul 2010 02:29:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 05444-05 for ; Sat, 17 Jul 2010 05:29:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.8]) by mail.postgresql.org (Postfix) with ESMTP id 71265632D2A for ; Sat, 17 Jul 2010 02:29:50 -0300 (ADT) Received: from [192.168.1.3] (static-71-179-240-8.bltmmd.fios.verizon.net [71.179.240.8]) by mrelayeu.kundenserver.de (node=mreu0) with ESMTP (Nemesis) id 0LiGlL-1PMkjP1WLb-00nFbN; Sat, 17 Jul 2010 07:29:41 +0200 Message-ID: <4C413FC3.50005@2ndquadrant.com> Date: Sat, 17 Jul 2010 01:29:39 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: bluestar43@gmail.com CC: Scott Marlowe , Tom Lane , pgsql-admin@postgresql.org Subject: Re: Stumped by a version conflict. References: <25504.1279322937@sss.pgh.pa.us> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:W4uvGLiKp7o7ishl3mBA1QrLaiq4C8Wd5N+PTLHSQRJ DByX1pbF/hv+e2NLLGbePBnqs7IYjtRq+eTJF0qm3HhxWWv3Xj CNt3s7HzaOTPHzsGKBdB5iT1Lxn14u1X+xHpm/40majDk+5Uag tB0z4ymJLCKTsUdlKD06BC5b3ulB6Q65ZLPUqTpMYBQl9UK0ic YhSExfe/dO5fVZ6QkWyXQvKl7/JJbMKk/+EbeBYFHE= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201007/131 X-Sequence-Number: 35150 Patric Michael wrote: > /usr/share/pgsql/postgresql.conf.sample > /var/lib/pgsql/data/postgresql.conf > /home/archives/db/postgresql.conf > /home/postgres/data/postgresql.conf > > The first line is the --datadir as reported by pg_configure --configure > The second line is the 7.4 data dir according to its PG_VERSION > The third line was a directory backup I made when I upgraded to 8.1 > The fourth line is the most recently updated database according to the > time stamps. (three days ago) Is there a PG_VERSION suggesting the 4th one is an 8.1 system? It's completely possible you manually started the database cluster like this: pg_ctl start -D /home/postgres/data And that's the one that's been running for the last two years. The default system PostgreSQL install is going to point at /var/lib/pgsql/data by default and try to start whatever database is there, which is the 7.4 one and therefore won't start with your current binaries. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us