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