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

Re: Postmaster 7.1.2 hanging

From: Justin Clift <justin(at)postgresql(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Justin Clift <aa2(at)bigpond(dot)net(dot)au>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postmaster 7.1.2 hanging
Date: 2001-07-07 06:08:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Hi Tom,

I had to kill -9 the postmaster process and go from there about 2
minutes after sending that email.  Although the data wasn't important,
the availability of PostgreSQL on the server was.  Had to get it up and
running again asap.

If it happens again, I'll attach a debugger to the postmaster process as
you've suggested and see what it thinks is going on.


Regards and best wishes,

Justin Clift

Tom Lane wrote:
> Justin Clift <aa2(at)bigpond(dot)net(dot)au> writes:
> > Just did a :
> > pg_ctl stop -m fast
> > And the postmaster process won't die.
> Can't duplicate it here.  Can you attach to the postmaster process with
> a debugger and see what it thinks its state is?  The static variables in
> postmaster.c are the things to look at.  Are there still entries
> in BackendList?  Are any of StartupPID, ShutdownPID, CheckPointPID
> nonzero?  What's the value of Shutdown?  Etc.
>                         regards, tom lane
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2001-07-07 09:24:19
Subject: Re: Perl DBI Module fails to install correctly from RPM
Previous:From: pgsql-bugsDate: 2001-07-07 01:31:30
Subject: can't create timestamp field (only timestamp with time zone)

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