| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Richard Doust <rdoust(at)mac(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Desparate: Lost WAL files |
| Date: | 2005-07-06 18:53:00 |
| Message-ID: | 200507061853.j66Ir0221445@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Doust | 2005-07-06 18:59:15 | Re: Desparate: Lost WAL files |
| Previous Message | Joshua D. Drake | 2005-07-06 18:51:52 | Re: Desparate: Lost WAL files |