Re: Desparate: Lost WAL files - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Desparate: Lost WAL files
Date
Msg-id 200507061853.j66Ir0221445@candle.pha.pa.us
Whole thread Raw
In response to Desparate: Lost WAL files  (Richard Doust <rdoust@mac.com>)
List pgsql-admin
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.
> Thanks in advance.

Have you tried pg_resetxlog to get it started?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Desparate: Lost WAL files
Next
From: Richard Doust
Date:
Subject: Re: Desparate: Lost WAL files