postmaster won't start after 'kill -9'
Carlo Florendo <[email protected]> Wed, 22 Dec 2004 08:58:04 +0800
| Newsgroups | gmane.comp.db.postgresql.cygwin |
|---|---|
| Message-ID | <[email protected]> |
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