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 4D839D1B1E0 for ; Mon, 14 Jun 2004 10:56:10 -0300 (ADT) 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 95199-01 for ; Mon, 14 Jun 2004 13:56:07 +0000 (GMT) Received: from ns1.turtle-entertainment.de (ns1.turtle-entertainment.de [193.41.200.20]) by svr1.postgresql.org (Postfix) with ESMTP id BE2A3D1B1F9 for ; Mon, 14 Jun 2004 10:56:02 -0300 (ADT) Received: from ip96.85.1311c-cud12k-02.ish.de ([62.143.85.96] helo=mail.office.turtle-entertainment.de) by ns1.turtle-entertainment.de with asmtp (Exim 3.22 #3 (Debian)) id 1BZrwO-00009g-00; Mon, 14 Jun 2004 15:56:00 +0200 Received: from ip19.1.1411j-cud12k-02.ish.de ([62.143.1.19] helo=[192.168.100.5]) by mail.office.turtle-entertainment.de with asmtp (Exim 3.22 #7 (Debian)) id 1BZrwO-00016k-00; Mon, 14 Jun 2004 15:56:00 +0200 Message-ID: <40CDAE6B.90400@turtle-entertainment.de> Date: Mon, 14 Jun 2004 15:55:55 +0200 From: Bjoern Metzdorf User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Barry Clearwater Cc: pgsql-admin@postgresql.org Subject: Re: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001" References: <1087202682.5267.94.camel@localhost> In-Reply-To: <1087202682.5267.94.camel@localhost> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.6 tagged_above=0.0 required=5.0 tests=RCVD_IN_DYNABLOCK, RCVD_IN_SORBS X-Spam-Level: ** X-Archive-Number: 200406/168 X-Sequence-Number: 13828 Barry Clearwater wrote: > LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001" > (log file 0, segment 1): No such file or directory > LOG: invalid primary checkpoint record > > Is there any way I can recreate a checkpoint record or resurrect any > data from postgresql. How important was the 0000000000000001 file ? check pg_resetxlog from postgresql/bin Regards, Bjoern