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