X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9B62532A1D4 for ; Thu, 30 Sep 2004 17:30:19 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60897-01 for ; Thu, 30 Sep 2004 16:30:10 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 5E4F832A1D2 for ; Thu, 30 Sep 2004 17:30:10 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i8UGU9lA017872; Thu, 30 Sep 2004 12:30:09 -0400 (EDT) To: akanksha kulkarni Cc: pgsql-admin@postgresql.org Subject: Re: reconstructing database In-reply-to: <20040930154318.79906.qmail@web52908.mail.yahoo.com> References: <20040930154318.79906.qmail@web52908.mail.yahoo.com> Comments: In-reply-to akanksha kulkarni message dated "Thu, 30 Sep 2004 08:43:18 -0700" Date: Thu, 30 Sep 2004 12:30:09 -0400 Message-ID: <17871.1096561809@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/288 X-Sequence-Number: 14991 akanksha kulkarni writes: > Is there any way to reconstruct database from data > files that are present in > /var/lib/pgsql/data/ > Actually I upgraded to new version of postgres (7.4) > but again reverted back to older version (7.2) after > uninstalling new version. That alone would not have broken your data, because the new version would have refused to start in an older data directory, and so it would not have modified the existing files. I think you are neglecting to tell us what you actually did. regards, tom lane