Re: Continuing issues... Can't vacuum!

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