Postgres Pro
Downloads
Home   >   mailing lists

Re: Can I copy data file and use it with other version of Postgresql - Mailing list pgsql-admin

From Tom Lane
Subject Re: Can I copy data file and use it with other version of Postgresql
Date
Msg-id 27774.1169403018@sss.pgh.pa.us
Whole thread Raw
In response to Can I copy data file and use it with other version of Postgresql  (ABC <marblerock26@yahoo.com>)
List pgsql-admin
Tree view 
ABC <marblerock26@yahoo.com> writes:
> FATAL:  database files are incompatible with server
> DETAIL:  The database cluster was initialized with PG_CONTROL_VERSION 0, but the server was compiled with
PG_CONTROL_VERSION72. 

It looks to me like something has happened to your pg_control file :-(
What does pg_controldata show?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Uregent- data Recovery - PG_CONTROL_VERSION mismatch
Next
From: "Rajesh Kumar Mallah"
Date:
Subject: Getting previous statements executed a backend currenly in an in transaction state.