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