Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id DA861B5DBE3 for ; Mon, 10 Oct 2011 12:55:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 43619-07 for ; Mon, 10 Oct 2011 15:55:40 +0000 (UTC) X-Greylist: delayed 00:05:28.085706 by SQLgrey-1.8.0-rc2 Received: from EXCASHUBA.onmobile.com (unknown [124.30.188.115]) by mail.postgresql.org (Postfix) with ESMTP id 18CDDB5DBE1 for ; Mon, 10 Oct 2011 12:55:38 -0300 (ADT) Received: from MUSCA.onmobile.com ([172.16.28.141]) by EXCASHUBA.onmobile.com ([172.16.28.183]) with mapi; Mon, 10 Oct 2011 21:25:02 +0530 From: Akash Kodibail To: "pgsql-admin@postgresql.org" Date: Mon, 10 Oct 2011 21:24:57 +0530 Subject: Postgres Server crashed Thread-Topic: Postgres Server crashed Thread-Index: AcyHZPWuX4Sq/ei3QcSZKZvbCw5w4Q== Message-ID: <04DA5C9AF2453F44ACD4541A08EFE9832D0CF8EE87@MUSCA.onmobile.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-cr-hashedpuzzle: BTX9 BhQ7 By4T C2/r DXi0 Eiel Ey4x F1C5 GB3d G3Xl G7vW HYMa HhEA ICzs IwiM JWLK; 1; cABnAHMAcQBsAC0AYQBkAG0AaQBuAEAAcABvAHMAdABnAHIAZQBzAHEAbAAuAG8AcgBnAA==; Sosha1_v1; 7; {E3188D0D-0F70-43DB-88B0-0611C84D8B31}; YQBrAGEAcwBoAC4AawBvAGQAaQBiAGEAaQBsAEAAbwBuAG0AbwBiAGkAbABlAC4AYwBvAG0A; Mon, 10 Oct 2011 15:54:57 GMT;UABvAHMAdABnAHIAZQBzACAAUwBlAHIAdgBlAHIAIABjAHIAYQBzAGgAZQBkAA== x-cr-puzzleid: {E3188D0D-0F70-43DB-88B0-0611C84D8B31} acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_04DA5C9AF2453F44ACD4541A08EFE9832D0CF8EE87MUSCAonmobile_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.106 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RDNS_NONE=0.793 X-Spam-Level: X-Archive-Number: 201110/44 X-Sequence-Number: 38496 --_000_04DA5C9AF2453F44ACD4541A08EFE9832D0CF8EE87MUSCAonmobile_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi All, I am a noob in database field. Lately the postgres server crashed due to space constraints, pg_control fil= e got lost and the server wouldn't start. Had a old pg_control file placed = in $PGDATA/global/ path. I was able to start the server, however, the data seems to be a very old on= e (2011 Jan 07) (probably the time where pg_control I had pasted was last u= pdated). How do I recover the rest of the data? The data directory seems to= be showing entire data, I am guessing so, because the major 4 tables which= seemed to be missed are the only contributors to around 100 GB and the DAT= APATH still says 163 GB is utilized. When trying to take a pg_dump, it says : pg_dump: schema with OID 29257 doe= s not exist, this OID is there in pg_type, but not there in any other catal= og tables. Please help me!! Regards, Akash. ________________________________ DISCLAIMER: The information in this message is confidential and may be lega= lly privileged. It is intended solely for the addressee. Access to this mes= sage by anyone else is unauthorized. If you are not the intended recipient,= any disclosure, copying, or distribution of the message, or any action or = omission taken by you in reliance on it, is prohibited and may be unlawful.= Please immediately contact the sender if you have received this message in= error. Further, this e-mail may contain viruses and all reasonable precaut= ion to minimize the risk arising there from is taken by OnMobile. OnMobile = is not liable for any damage sustained by you as a result of any virus in t= his e-mail. All applicable virus checks should be carried out by you before= opening this e-mail or any attachment thereto. Thank you - OnMobile Global Limited. --_000_04DA5C9AF2453F44ACD4541A08EFE9832D0CF8EE87MUSCAonmobile_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi All,

 

I am a noob in database field.

 

Lately the postgres server crashed due to space cons= traints, pg_control file got lost and the server wouldn’t start. Had = a old pg_control file placed in $PGDATA/global/ path.

 

I was able to start the server, however, the data se= ems to be a very old one (2011 Jan 07) (probably the time where pg_control = I had pasted was last updated). How do I recover the rest of the data? The = data directory seems to be showing entire data, I am guessing so, because the major 4 tables which seemed to = be missed are the only contributors to around 100 GB and the DATAPATH still= says 163 GB is utilized.

 

When trying to take a pg_dump, it says : pg_dump: sc= hema with OID 29257 does not exist, this OID is there in pg_type, but not t= here in any other catalog tables.

 

Please help me!!

 

Regards,

Akash.


DISCLAIMER: The information = in this message is confidential and may be legally privileged. It is intend= ed solely for the addressee. Access to this message by anyone else is unaut= horized. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or = omission taken by you in reliance on it, is prohibited and may be unlawful.= Please immediately contact the sender if you have received this message in= error. Further, this e-mail may contain viruses and all reasonable precaution to minimize the risk arising= there from is taken by OnMobile. OnMobile is not liable for any damage sus= tained by you as a result of any virus in this e-mail. All applicable virus= checks should be carried out by you before opening this e-mail or any attachment thereto.
Thank you - OnMobile Global Limited.
 --_000_04DA5C9AF2453F44ACD4541A08EFE9832D0CF8EE87MUSCAonmobile_--