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@cns.vt.edu> writes: > > > [ postgresql@stell ~]$ pg_ctl restart -D /var/pgsql/data > > > waiting for postmaster to shut > > > down............................................................... > > > failed pg_ctl: postmaster does not shut down > > > [postgresql@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
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster