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 B1E0F5284E for ; Wed, 6 Jul 2005 15:59:36 -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 52463-10 for ; Wed, 6 Jul 2005 18:59:27 +0000 (GMT) Received: from smtpout.mac.com (smtpout.mac.com [17.250.248.44]) by svr1.postgresql.org (Postfix) with ESMTP id 5266E52815 for ; Wed, 6 Jul 2005 15:59:24 -0300 (ADT) Received: from mac.com (smtpin01-en2 [10.13.10.146]) by smtpout.mac.com (Xserve/8.12.11/smtpout12/MantshX 4.0) with ESMTP id j66IxNvU025228; Wed, 6 Jul 2005 11:59:23 -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 j66IxKdX012558; Wed, 6 Jul 2005 11:59:21 -0700 (PDT) In-Reply-To: <42CC2848.3050107@commandprompt.com> References: <2C386A13-7865-49FD-BB6C-953A24A4201D@mac.com> <42CC2848.3050107@commandprompt.com> Mime-Version: 1.0 (Apple Message framework v730) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit From: Richard Doust Subject: Re: Desparate: Lost WAL files Date: Wed, 6 Jul 2005 11:59:15 -0700 To: "Joshua D. Drake" , Bruce Momjian 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/32 X-Sequence-Number: 18088 Thanks guys. I didn't know about this command. It worked like a charm. Like I said, I had done a clean shutdown. Thanks again. On Jul 6, 2005, at 11:51 AM, Joshua D. Drake wrote: > Richard Doust wrote: > >> 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. >> > > Well the exact error would be good just in case but you may be able > to use pg_resetxlog to get the machine back up. However you will > have no > idea what state the database itself is in. > > You need to restore from backup. > > Sincerely, > > Joshua D. Drake > > > > >> Thanks in advance. >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 1: subscribe and unsubscribe commands go to >> majordomo@postgresql.org >> > > > -- > Your PostgreSQL solutions company - Command Prompt, Inc. > 1.800.492.2240 > PostgreSQL Replication, Consulting, Custom Programming, 24x7 support > Managed Services, Shared and Dedicated Hosting > Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ >