Message-ID: <483742C9.6000906@frostconsultingllc.com>
Date: Fri, 23 May 2008 15:18:49 -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>
	<483733F5.6020703@frostconsultingllc.com>
	<4FAAB56B-864B-4B20-858A-4D5D0EA9E12E@indiana.edu>
In-Reply-To: <4FAAB56B-864B-4B20-858A-4D5D0EA9E12E@indiana.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


Carol Walter wrote:
> -bash-3.00$ ps -ef | grep post
> postgres  9631  9629   0   Sep 24 ?          30:28 
> /opt/csw/postgresql/bin/sparcv8/postgres -D /dbpdisk/postgres/prod_823
> postgres  9633  9629   0   Sep 24 ?          96:31 
> /opt/csw/postgresql/bin/sparcv8/postgres -D /dbpdisk/postgres/prod_823
> postgres  9634  9629   0   Sep 24 ?          67:28 
> /opt/csw/postgresql/bin/sparcv8/postgres -D /dbpdisk/postgres/prod_823
> postgres  9629  9396   0   Sep 24 ?          13:26 
> /opt/csw/postgresql/bin/sparcv8/postgres -D /dbpdisk/postgres/prod_823
> postgres 12082 12029   0 17:57:06 pts/17      0:00 ps -ef
> postgres 12029  3950   0 17:55:05 pts/17      0:00 -bash
> postgres 12083 12029   0 17:57:06 pts/17      0:00 grep post
>
> I running under Solaris 10.  I don't have anything that looks exactly 
> like what you here, but the postgres has got to be running.  I can go 
> in as the postgres user connect to different databases and select data 
> from them.  This installation was loaded by my colleague using a 
> product called Blastwave hence the csw directories.
>
> By the way, and not incidentally, thank you for the help.
Looks like pid 9629 is the parent of all of them, so if you simply:

kill 9629

they should all exit gracefully.  You can check this with the same ps 
command.

Then you should be able to: "pg_ctl -D /dbpdisk/postgres/prod_823 start" 
as the postgres user to start it back up.

I think you might want to have a look at the /etc/init.d/postgresql (or 
whatever the startup script is) because it doesn't look to be using 
pg_ctl to start postgresql  since the pid file was missing or ask your 
colleague how it was started in the first place.  I'm not sure on 
Solaris if the ps output gets changed like it does in linux to reflect 
the processes role.  In linux those would probably look more like this:

postgres  2525     1  0 May02 ?        00:01:04 /usr/bin/postmaster -p 
5432 -D /var/lib/pgsql/data
postgres  2649  2525  0 May02 ?        00:00:21 postgres: logger process
postgres  2662  2525  0 May02 ?        00:03:18 postgres: writer process
postgres  2663  2525  0 May02 ?        00:02:12 postgres: wal writer process
postgres  2664  2525  0 May02 ?        00:07:16 postgres: autovacuum 
launcher process
postgres  2665  2525  0 May02 ?        00:04:56 postgres: stats 
collector process


-- 
Jeff Frost, Owner 	<jeff@frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954