• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 978
  • Last Modified:

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
0
m_sharma98
Asked:
m_sharma98
  • 2
  • 2
  • 2
2 Solutions
 
RobsonCommented:
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.
0
 
earth man2Commented:
Reinstall Postgresql 7.3
pgdump
Reinstall PostgreSQL 8.3
install database dump.

I would not use 7.4 for production use.
0
 
m_sharma98Author Commented:
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
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
m_sharma98Author Commented:
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.
0
 
earth man2Commented:
You MUST use PostgreSQL 7.3 FULL STOP.

If you want ro upgrade you export the database using pg_dump utility.  Import to Postgres 7.4 or 8.3 using psql.
0
 
RobsonCommented:
> But how can I get the verion number which is running on .
select version();

> And How can I put it in initialization scripts?
Thats not postgresql stuff: it depends on your system.

R.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now