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

postmaster won't start after 'kill -9'

From
Carlo Florendo
Date:
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


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

From
"Mike G."
Date:
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