Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9F1BC9FB56C for ; Sun, 21 Jan 2007 10:02:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 21680-04 for ; Sun, 21 Jan 2007 10:01:48 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by postgresql.org (Postfix) with ESMTP id 43DD59FB572 for ; Sun, 21 Jan 2007 10:01:59 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so1064595nfb for ; Sun, 21 Jan 2007 06:01:57 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=MwxKLh5kJIzzkrsyg2Y42dk7Wfja6CpppPg3p44W0J2OQNLo00J/V3SSt1/NGkZ05tl+zuoTeF79w2QTAeFiM5oFtRJxX0F+/MVPC/NB9p66jyDpvoG3HxG+DIxPH1RNyR06bEZzDYj+6lhbkoAX2AVWKdL7Oa1z3W28GZp0xFE= Received: by 10.48.48.18 with SMTP id v18mr5056323nfv.1169388113314; Sun, 21 Jan 2007 06:01:53 -0800 (PST) Received: by 10.48.230.1 with HTTP; Sun, 21 Jan 2007 06:01:53 -0800 (PST) Message-ID: <81961ff50701210601l1bebca03jbc069e47c942910f@mail.gmail.com> Date: Sun, 21 Jan 2007 09:01:53 -0500 From: "Chad Wagner" To: ABC Subject: Re: Can I copy data file and use it with other version of Postgresql Cc: pgsql-admin@postgresql.org In-Reply-To: <627445.72610.qm@web61213.mail.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_45664_19894645.1169388113293" References: <627445.72610.qm@web61213.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/181 X-Sequence-Number: 24337 ------=_Part_45664_19894645.1169388113293 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 1/21/07, ABC wrote: > > 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 ??. > Not in this case, you have to dump and restore. You can *usually* take the data files from "patch" releases, say 8.2.0 to 8.2.1, but minor releases such as 8.1 to 8.2 often do not work because of changes in data layouts, pg_catalog changes, etc. It looks like your original data was on 7.2, best bet is to build a 7.2 server, start up, dump and then restore to the new server. -- Chad http://www.postgresqlforums.com/ ------=_Part_45664_19894645.1169388113293 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
On 1/21/07, ABC <marblerock26@yahoo.com> wrote:
 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 ??.

Not in this case, you have to dump and restore.  You can *usually* take the data files from "patch" releases, say 8.2.0 to 8.2.1, but minor releases such as 8.1 to 8.2 often do not work because of changes in data layouts, pg_catalog changes, etc.  It looks like your original data was on 7.2, best bet is to build a 7.2 server, start up, dump and then restore to the new server.

--
Chad
http://www.postgresqlforums.com/ ------=_Part_45664_19894645.1169388113293--