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

Hi, Jeff,

Here's the output from the command.

-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.

Carol

On May 23, 2008, at 5:15 PM, Jeff Frost wrote:

> 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?
>
>