From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Cc: | Ray Stell <stellr(at)cns(dot)vt(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: restart error |
Date: | 2006-10-05 20:31:06 |
Message-ID: | 200610051631.06914.sdavis2@mail.nih.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Thursday 05 October 2006 16:26, Ray Stell wrote:
> On Wed, Oct 04, 2006 at 01:28:37PM -0400, Tom Lane wrote:
> > Ray Stell <stellr(at)cns(dot)vt(dot)edu> writes:
> > > [postgresql(at)stell ~]$ pg_ctl restart -D /var/pgsql/data
> > > waiting for postmaster to shut
> > > down...............................................................
> > > failed pg_ctl: postmaster does not shut down
> > > [postgresql(at)stell ~]$
> > >
> > > yet postmaster is gone:
> >
> > Looking at the code, it seems that pg_ctl is waiting for the postmaster
> > lock file (/var/pgsql/data/postmaster.pid) to disappear. Perhaps you've
> > got some kind of file permissions bollix that prevented the postmaster
> > from removing that file?
>
> Turns out I had an open session in another shell I'd
> forgotten about. I tried again with similar results and
> as I sent \q on the outstanding session, pm went down instantly:
select * from pg_stat_activity;
is your friend.
Sean
From | Date | Subject | |
---|---|---|---|
Next Message | Shoaib Mir | 2006-10-05 20:35:52 | Re: restart error |
Previous Message | Ray Stell | 2006-10-05 20:26:02 | Re: restart error |