Re: Stumped by a version conflict. - Mailing list pgsql-admin

From Patric Michael
Subject Re: Stumped by a version conflict.
Date
Msg-id AANLkTindFYOr_RZj2zRnD6TNFgua8R2Sl7L2DNm4Ml9G@mail.gmail.com
Whole thread Raw
In response to Re: Stumped by a version conflict.  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-admin
Hi Greg...

On Fri, Jul 16, 2010 at 10:29 PM, Greg Smith <greg@2ndquadrant.com> wrote:
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:

Nope.  The PG_VERSION in the last one shows 7.4

pg_ctl start -D /home/postgres/data

It would be consistent that I did manually start the cluster, given that the uptime was considerably longer than two years. 

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.

Correct, but I did edit the scripts to point to the current data directory.  Further, trying to manually start the cluster now using the command above give me this:

FATAL:  database files are incompatible with server
DETAIL:  The data directory was initialized by PostgreSQL version 7.4, which is not compatible with this version 8.1.11.

Which is of course what has me stumped.  I cannot shake the idea that I am forgetting or missing something really simple or obvious, and that when I figure it out there'll be a dent in the desk from where I've been banging my head on it.  :)


--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us


pgsql-admin by date:

Previous
From: Greg Smith
Date:
Subject: Re: Stumped by a version conflict.
Next
From: Robert Voinea
Date:
Subject: Re: Weird sorting order