Re: Stumped by a version conflict.

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