Forum OpenACS Q&A: Re: database recovery: how does postgres unix work?

Posted by Eric Wolfram on
Thanks for the help and reality check. I needed to set it right -- but that brings up a new issue.

bash-2.05$ export PGDATA=/tmp/data_bak/data
bash-2.05$ pg_ctl start
postmaster successfully started
bash-2.05$ FATAL 1: The data directory was initialized by PostgreSQL version 7.2, which is not compatible with this version 7.1.3.

I'm sure I installed 7.2.3, ie:

[root@rhumba local]# ls
bin doc etc games include lib libexec pgsql postgresql-7.2.3 postgresql-7.2.3.tar sbin share src

Why would the system think it's 7.1.3?

[root@rhumba local]# ps auxww | grep sql
postgres 28668 0.0 0.5 5300 1328 pts/1 S 16:43 0:00 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
root 29572 0.0 0.1 1476 460 pts/2 R 19:38 0:00 grep sql
[root@rhumba local]#

I get the feeling that I have enough sql-rope to hang myself. :-) I'm just remembering all the RPM dependency errors I was getting that made me try the 'download the tar version and gmake gmake install' way...

I guess no one said it would be easy. Why does the system think I have 7.1.3 when I just installed 7.2.3?