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

Re: postmaster won't start after 'kill -9'

From: "Mike G(dot)" <mike(at)thegodshalls(dot)com>
To: Carlo Florendo <list-subscriber(at)hq(dot)astra(dot)ph>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: postmaster won't start after 'kill -9'
Date: 2004-12-22 03:42:51
Message-ID: 20041222034251.GB10718@thegodshalls.thegodshalls (view raw or flat)
Thread:
Lists: pgsql-cygwin
Can you restore the directories you deleted?  They really should not have been deleted.

On Wed, Dec 22, 2004 at 08:58:04AM +0800, Carlo Florendo wrote:
> 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

In response to

pgsql-cygwin by date

Next:From: Lentes, BerndDate: 2004-12-22 10:16:47
Subject: Error: user does not exist
Previous:From: Carlo FlorendoDate: 2004-12-22 00:58:04
Subject: postmaster won't start after 'kill -9'

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