Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-cygwin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group