Skip site navigation (1) Skip section navigation (2)

Can I copy data file and use it with other version of Postgresql

From: ABC <marblerock26(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Can I copy data file and use it with other version of Postgresql
Date: 2007-01-21 13:02:10
Message-ID: 377204.77156.qm@web61217.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
 We are facing a probelm and its very urgent to sort it out. Please Help.
The database server unexpectedly shutdown down due to power failure. On reboot, Postgresql server fails to start giving following Error:
----------------------------------------------------------------------------------------------------------
LOG:  could not create IPv6 socket: Address family not supported by protocol
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_VERSION 72.
HINT:  It looks like you need to initdb.
----------------------------------------------------------------------------------------------------------

we are using  Mandrake  Linux 9.1 and two version of Postgresql Version-7.4.2 and  Postgresql Version-7.3.2 is installed
The Data directory is initialised with postgresql-7.4.2.
Postgresql  -7.3.2 is not used .Postgresql-7.4.2 is used for managing Postgres Server.

Can I copy the Data Files and use tht Data with other Version of Postgresql ??.

 
---------------------------------
Food fight? Enjoy some healthy debate
in the Yahoo! Answers Food & Drink Q&A.

pgsql-admin by date

Next:From: Chad WagnerDate: 2007-01-21 14:01:53
Subject: Re: Can I copy data file and use it with other version of Postgresql
Previous:From: ABCDate: 2007-01-21 13:00:39
Subject: Uregent- data Recovery - PG_CONTROL_VERSION mismatch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group