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 696625298F for ; Wed, 6 Jul 2005 16:08:15 -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 53597-09 for ; Wed, 6 Jul 2005 19:08:14 +0000 (GMT) Received: from smtpout.mac.com (smtpout.mac.com [17.250.248.47]) by svr1.postgresql.org (Postfix) with ESMTP id B8DE652993 for ; Wed, 6 Jul 2005 16:08:09 -0300 (ADT) Received: from mac.com (smtpin02-en2 [10.13.10.147]) by smtpout.mac.com (Xserve/8.12.11/smtpout09/MantshX 4.0) with ESMTP id j66J86KC011505; Wed, 6 Jul 2005 12:08:06 -0700 (PDT) Received: from [192.168.168.6] ([67.180.42.199]) (authenticated bits=0) by mac.com (Xserve/smtpin02/MantshX 4.0) with ESMTP id j66J84cb020734; Wed, 6 Jul 2005 12:08:05 -0700 (PDT) In-Reply-To: <42CC2AE9.5090404@commandprompt.com> References: <2C386A13-7865-49FD-BB6C-953A24A4201D@mac.com> <42CC2848.3050107@commandprompt.com> <42CC2AE9.5090404@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 12:08:01 -0700 To: "Joshua D. Drake" 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/34 X-Sequence-Number: 18090 Well, actually, (he said sheepishly) I deleted the WAL files myself. A bit of stupidity. On Jul 6, 2005, at 12:03 PM, Joshua D. Drake wrote: > Richard Doust wrote: > >> Thanks guys. >> I didn't know about this command. >> It worked like a charm. >> Like I said, I had done a clean shutdown. >> > > If you did a clean shutdown and you lost those files you quite likely > have a very serious problem. You should investigate your hardware. > Files don't just "disappear". > > Sincerely, > > Joshua D. Drake > > > >> 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/ >>> >>> > > > -- > 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/ >