postmaster won't start after 'kill -9'

From: Carlo Florendo <list-subscriber(at)hq(dot)astra(dot)ph>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: postmaster won't start after 'kill -9'
Date: 2004-12-22 00:58:04
Message-ID: 41C8C69C.8090101@hq.astra.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

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

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Mike G. 2004-12-22 03:42:51 Re: postmaster won't start after 'kill -9'
Previous Message David Liu 2004-12-20 23:42:56 psql hang in emacs/cygwin bash (postgresql-7.4.5)