Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 3A7D39FB4AA for ; Sun, 21 Jan 2007 09:00:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 24191-01 for ; Sun, 21 Jan 2007 09:00:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web61215.mail.yahoo.com (web61215.mail.yahoo.com [209.73.179.64]) by postgresql.org (Postfix) with SMTP id EE1849FA5D8 for ; Sun, 21 Jan 2007 09:00:40 -0400 (AST) Received: (qmail 36521 invoked by uid 60001); 21 Jan 2007 13:00:39 -0000 Message-ID: <20070121130039.36519.qmail@web61215.mail.yahoo.com> DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=tAJ0SSYoWDsieoQwOF7cvageKKA33i8ldJxBtPBM7Gwy7J7aMeqZDlnFaWvX9z5GNxnrEcQ0TnB7pgs6PoGTay7M3iQG+7xKwEJMClGNNHAMJAyjCKEjRR+31YRsc2cN+HNWiXI364Sg53mutrY7bK8XdCJuR/mSm6yP+1iOdT8=; X-YMail-OSG: 1Au0HpoVM1kfxOKH3xqVde8d2KCCi16.TwKrnd0JgZMFoPEv3W9Gu8Qc7EAzv_kEIoQzvtqWA.KIGiT6CttQ2jkcTSjMpSnAdxQUMS7AvJettuNqZY5raLApbE2bU_Pb66vp4w.PmfYegpZrO2wV_OnInC.UskCm2WUpSM1yBTpW8Fc- Received: from [203.101.126.221] by web61215.mail.yahoo.com via HTTP; Sun, 21 Jan 2007 05:00:39 PST Date: Sun, 21 Jan 2007 05:00:39 -0800 (PST) From: ABC Subject: Uregent- data Recovery - PG_CONTROL_VERSION mismatch To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1358370895-1169384439=:35592" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.77 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_10_20, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200701/180 X-Sequence-Number: 24336 --0-1358370895-1169384439=:35592 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. We have tried to initialize a new data directory and then copy the contents of previous data directory (which is failed to start) into the new directory after that while starting postmaster from the new dir it gives the same message describe above so, we have tried this one and after that we are able to start the database but now we are unable to use the data the select queries returns 0 rows or giving error [ERROR: invalid attribute number 0 for ] also we are not able to dump the database the command pg_dump gives folowing error and then exit pg_dump: schema with OID 536944636 does not exist Please suggest any solution . Its very urgent. Thanks And Regards Chandrakant Chouhan --------------------------------- Sucker-punch spam with award-winning protection. Try the free Yahoo! Mail Beta. --0-1358370895-1169384439=:35592 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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.

We have tried to initialize a new data directory and then copy the contents of previous data directory (which is failed to start) into the new directory
after that while starting postmaster from the new dir it gives the same message describe above

so, we have tried this one and after that we are able to start the database but now we are unable to use the data
the select queries returns 0 rows or giving error [ERROR:  invalid attribute number 0 for <table-name>]

also we are not able to dump the database the command pg_dump gives folowing error and then exit

pg_dump: schema with OID 536944636 does not exist

Please  suggest any solution . Its very urgent.
Thanks And Regards
Chandrakant Chouhan


Sucker-punch spam with award-winning protection.
Try the free Yahoo! Mail Beta. --0-1358370895-1169384439=:35592--