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