Message-ID: <483733F5.6020703@frostconsultingllc.com>
Date: Fri, 23 May 2008 14:15:33 -0700
From: Jeff Frost <jeff@frostconsultingllc.com>
Organization: Frost Consulting, LLC
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
To: Carol Walter <walterc@indiana.edu>
CC: Kevin Grittner <Kevin.Grittner@wicourts.gov>,
	"Joshua D. Drake" <jd@commandprompt.com>, pgsql-admin@postgresql.org
Subject: Re: Continuing issues... Can't vacuum!
References: <5897F703-1525-477B-8749-80A0A4E0A656@indiana.edu>
	<1211565622.17493.24.camel@jd-laptop>
	<3C9DB43B-9B3D-4E55-B4DE-37E83A1CA136@indiana.edu>
	<1211567980.17493.36.camel@jd-laptop>
	<DC21DF01-8565-41A9-BD41-0B4B8535A259@indiana.edu>
	<4836CDEA.EE98.0025.0@wicourts.gov>
	<7B88EF79-78A5-4476-8A54-7EA42042A727@indiana.edu>
In-Reply-To: <7B88EF79-78A5-4476-8A54-7EA42042A727@indiana.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Carol Walter wrote:
> Hi, Again.
>
> I tried this and got the same message.  It is as follows:
>
> -bash-3.00$ /opt/csw/postgresql/bin/pg_ctl -D 
> /dbpdisk/postgres/prod_823 -m fas
> t stop
> pg_ctl: PID file "/dbpdisk/postgres/prod_823/postmaster.pid" does not 
> exist
> Is server running?
>
> Are there other ideas?

Carol, what does:

ps -ef | grep postgres

return?

If postgres is really running, there should be a postmaster process that 
shows which directory it's using as the DATA directory.  It'll look 
something like this:

postgres 24080     1  0 09:49 ?        00:00:07 /usr/bin/postmaster -p 
5432 -D /var/lib/pgsql/data

If there isn't a postmaster, it's possible someone started postgres with 
the -D option directly.

If you have multiple postgres server's running on the same machine, 
you'll see multiple postmasters.

BTW: What operating system is this running under?  If linux, which 
distribution?