Re: [ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Joshua D. Drake
Richard Doust wrote: Well, actually, (he said sheepishly) I deleted the WAL files myself. A bit of stupidity. Doh! In the future it would probably be wise to *not* do that ;) Sincerely, Joshua D. Drake On Jul 6, 2005, at 12:03 PM, Joshua D. Drake wrote: Richard Doust wrote: Thanks g

Re: [ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Richard Doust
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

Re: [ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Joshua D. Drake
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 "disap

Re: [ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Richard Doust
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 director

Re: [ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Bruce Momjian
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 r

Re: [ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Joshua D. Drake
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 i

[ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Richard Doust
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