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 32B7252998 for ; Wed, 6 Jul 2005 15:36:00 -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 46965-09 for ; Wed, 6 Jul 2005 18:35:52 +0000 (GMT) Received: from smtpout.mac.com (smtpout.mac.com [17.250.248.72]) by svr1.postgresql.org (Postfix) with ESMTP id 4AB9352815 for ; Wed, 6 Jul 2005 15:35:51 -0300 (ADT) Received: from mac.com (smtpin01-en2 [10.13.10.146]) by smtpout.mac.com (Xserve/8.12.11/smtpout15/MantshX 4.0) with ESMTP id j66IZoQi003316 for ; Wed, 6 Jul 2005 11:35:50 -0700 (PDT) Received: from [192.168.168.6] ([67.180.42.199]) (authenticated bits=0) by mac.com (Xserve/smtpin01/MantshX 4.0) with ESMTP id j66IZn0x002281 for ; Wed, 6 Jul 2005 11:35:49 -0700 (PDT) Mime-Version: 1.0 (Apple Message framework v730) Content-Transfer-Encoding: 7bit Message-Id: <2C386A13-7865-49FD-BB6C-953A24A4201D@mac.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: pgsql-admin@postgresql.org From: Richard Doust Subject: Desparate: Lost WAL files Date: Wed, 6 Jul 2005 11:35:45 -0700 X-Mailer: Apple Mail (2.730) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/29 X-Sequence-Number: 18085 Hi. Can anyone please tell me what I can do? I've lost the contents of my pg_xlog directory and postmaster is failing to start because it can't find a valid checkpoint record. It had done a clean shutdown, so I know that the dbms should be okay if I could just restart it. I'm in a desparate situation. It's a production database. Thanks in advance.