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

Re: restart error

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: sdavis2(at)mail(dot)nih(dot)gov
Cc: pgsql-novice(at)postgresql(dot)org, "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:35:52
Message-ID: bf54be870610051335n29e4ba46p7d270058a9f32bed@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
OR you can use

pg_ctl -D <data-folder> -mf

Thanks,
----
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 10/6/06, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

Responses

pgsql-novice by date

Next:From: Ray StellDate: 2006-10-05 20:44:19
Subject: Re: restart error
Previous:From: Sean DavisDate: 2006-10-05 20:31:06
Subject: Re: restart error

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