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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-cygwin by date

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