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 05209D1B1F9 for ; Mon, 14 Jun 2004 05:59:03 -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 57828-05 for ; Mon, 14 Jun 2004 08:59:00 +0000 (GMT) Received: from smtp2.clear.net.nz (smtp2.clear.net.nz [203.97.37.27]) by svr1.postgresql.org (Postfix) with ESMTP id 182C7D1B1D0 for ; Mon, 14 Jun 2004 05:58:57 -0300 (ADT) Received: from 218-101-117-110.dialup.clear.net.nz (218-101-117-110.dialup.clear.net.nz [218.101.117.110]) by smtp2.clear.net.nz (CLEAR Net Mail) with ESMTP id <0HZA00I51JM9ZO@smtp2.clear.net.nz> for pgsql-admin@postgresql.org; Mon, 14 Jun 2004 20:58:59 +1200 (NZST) Date: Mon, 14 Jun 2004 20:55:44 +1200 From: Barry Clearwater Subject: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001" To: pgsql-admin@postgresql.org Message-id: <1087202682.5267.94.camel@localhost> MIME-version: 1.0 X-Mailer: Ximian Evolution 1.4.5-4mdk Content-type: text/plain Content-transfer-encoding: 7bit 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: 200406/164 X-Sequence-Number: 13824 Having sucessfully crashed sql ledger and desperate to see if I can start it again, I read a posting by Lamar Owen which helped me get a meaningful output to debug. Problem started when I inadvertantly started the computer at a date in the future. Now I found I have deleted an important file (0000000000000001) -not a very useful name, I assumed it was a log file. bash-2.05b$ LOG: database system was interrupted at 2004-07-23 00:40:11 NZST 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 LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001" (log file 0, segment 1): No such file or directory LOG: invalid secondary checkpoint record PANIC: could not locate a valid checkpoint record LOG: startup process (PID 9970) was terminated by signal 6 LOG: aborting startup due to startup process failure Is there any way I can recreate a checkpoint record or resurrect any data from postgresql. How important was the 0000000000000001 file ? Thank you Barry Clearwater