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 22FB732A640 for ; Fri, 8 Oct 2004 21:17:54 +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 47647-10 for ; Fri, 8 Oct 2004 20:17:20 +0000 (GMT) Received: from web52901.mail.yahoo.com (web52901.mail.yahoo.com [206.190.39.178]) by svr1.postgresql.org (Postfix) with SMTP id CCC1E32A2B0 for ; Fri, 8 Oct 2004 21:17:20 +0100 (BST) Message-ID: <20041008201716.19470.qmail@web52901.mail.yahoo.com> Received: from [68.167.147.42] by web52901.mail.yahoo.com via HTTP; Fri, 08 Oct 2004 13:17:16 PDT Date: Fri, 8 Oct 2004 13:17:16 -0700 (PDT) From: akanksha kulkarni Subject: HELP -- pgfsck, pg_resetxlog not working for me. To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_DNS_FOR_FROM X-Spam-Level: * X-Archive-Number: 200410/136 X-Sequence-Number: 15129 Hi, I am trying to recover database. Earlier postmaster was not starting saying invalid primary and secondary checkpoints and a file in pg_xlog was not found. So I used pg_resetxlog. This made postmaster start. But I am not seeing most of the data and many tables. I then tried using pgfsck on my data directory but no luck. pgfsck would start saying 'Detected database format 7.2' but won't go beyond that saying 'couldn't find relation pg_attribute(). Please help me in recovering my database. I have data directory intact with pg_clog and pg_xlog files. However there are no files in 16555 in /data/base directory. I have used pg_filedump to view data files. I can see data but can't understand the usefulness of values in headers. Please HELP in recovering my database. Thanks, Akanksha Kulkarni __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail