Can you restore the directories you deleted? They really should not have been deleted.
On Wed, Dec 22, 2004 at 08:58:04AM +0800, Carlo Florendo wrote:
> Hello,
>
> I mistakenly did a 'kill -9' on postmaster and afterwads, postgresql
> won't start anymore. I've deleted everything under pg_xlog and pg_clog
> thinking the server would have to start all over again. However, I'm
> still not able to run the server.
>
> Here's the transcript of what happens:
>
> $ export CYGWIN=server
> $ postmaster -i -D /var/postgresql/data/
> WARNING: dup(0) failed after 3195 successes: Bad file descriptor
> LOG: database system shutdown was interrupted at 2004-12-09 17:06:57 TST
> LOG: could not open file
> "/var/postgresql/data/pg_xlog/0000000000000000" (log file 0, segment 0):
> No such file or directory
> LOG: invalid primary checkpoint record
> LOG: could not open file
> "/var/postgresql/data/pg_xlog/0000000000000000" (log file 0, segment 0):
> No such file or directory
> LOG: invalid secondary checkpoint record
> PANIC: could not locate a valid checkpoint record
> LOG: startup process (PID 1528) was terminated by signal 6
> LOG: aborting startup due to startup process failure
>
> I'll be glad for any pointers.
>
> Thanks!
>
> Best Regards,
>
> Carlo
>
> --
> Carlo Florendo
> Astra Philippines Inc.
> www.astra.ph
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend