On Fri, Jul 16, 2010 at 10:29 PM, Greg Smith <greg@xxxxxxxxxxxxxxx> wrote:
Nope. The PG_VERSION in the last one shows 7.4
It would be consistent that I did manually start the cluster, given that the uptime was considerably longer than two years.
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. :)
Patric Michael wrote: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:
/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)
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@xxxxxxxxxxxxxxx www.2ndQuadrant.us
