[ADMIN] New install - can't access pgsql

2006-01-04 Thread Richard Doust
I have just done a new compile and install of postgresql 8.1.0 on a Mac running OS X 10.4.3 Server. This machine hosted a postgres database in a production web application environment until recently when I moved the application and the database to a different host on the network. My intent

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 yo

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 m

[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