asked on

database files are incompatible with server

Hi to All,
I installed Postgresql 7.3.2 on linux.It was working fine upto now.
By mistake somebody restarted the linux.Now after restarting the postgresql it is giving the error below.
Please help me.I am not a DB guy.

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

Thanks in advance

Robson

It seems that you have two versions of PostgreSQL installed: 7.3 and 7.4.3. I suppose that someone started 7.3 version manually, initialized database with it, but did not put it in initialization scripts. After the restart version 7.4 started (why did you need older version for?).

Stop it, start version 7.3 and this time put it in initscripts.

R.

earth man2

Reinstall Postgresql 7.3
pgdump
Reinstall PostgreSQL 8.3
install database dump.

I would not use 7.4 for production use.

m_sharma98

ASKER

Thanks Robson,
But how can I get the verion number which is running on .
And How can I put it in initialization scripts?
Actuallu I am new to postgresql.Please help me

m_sharma98

ASKER

I am trying to start my db with the command below

/usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data dblog 2>&1 &

But it is also giving the same error.

ASKER CERTIFIED SOLUTION

earth man2

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Robson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial