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

Re: how to stop postmaster

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: KeithW(at)narrowpathinc(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: how to stop postmaster
Date: 2004-10-08 20:14:12
Message-ID: 15584.1097266452@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"Keith Worthington" <keithw(at)narrowpathinc(dot)com> writes:
> Here is what I did.

> $ postmaster -D /raid02/databases/

> $ pg_ctl stop -m smart
> pg_ctl: cannot find /var/lib/pgsql/data/postmaster.pid
> Is postmaster running?

pg_ctl evidently thinks that PGDATA is /var/lib/pgsql/data, which I
suppose it got from an environment variable you have set; but you
told the postmaster to use PGDATA = /raid02/databases.  So you need
	pg_ctl stop -D /raid02/databases/ -m whatever

Or change your environment variable.

> I would also like to know how to start the postmaster properly on a permanent
> basis.  For instance at boot time.

Usually people do that with an init script.  There's a simple one in the
source distribution (look in contrib/start-scripts) but you're probably
better off using the one that comes with the RPM distribution.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: V i s h a l Kashyap @ [Sai Hertz And Control Systems]Date: 2004-10-09 16:15:31
Subject: View or Function as default field
Previous:From: Keith WorthingtonDate: 2004-10-08 18:49:12
Subject: how to stop postmaster

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