problem with psql?

From: Timothy Perrigo <tperrigo(at)wernervas(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: problem with psql?
Date: 2005-11-28 19:24:37
Message-ID: CC9BA5B6-4685-457E-9B81-6452AC768BB9@wernervas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We just ran an OS update on an Xserve which runs our PostgreSQL
server, and now it seems that pg_ctl status doesn't report the
correct status.

~ postgres$ pg_ctl status
pg_ctl: neither postmaster nor postgres running

~ postgres$ ps auxw | grep postgres
postgres 491 0.0 -0.1 33156 1160 ?? S 1:09PM
0:00.16 /usr/local/pgsql/bin/postmaster -D /Volumes/DBRAID/pgsql/data
postgres 629 0.0 -0.0 31844 216 ?? S 1:09PM 0:00.27
postgres: logger process
postgres 631 0.0 -0.0 33140 744 ?? S 1:09PM 0:00.06
postgres: writer process
postgres 632 0.0 -0.0 31860 276 ?? S 1:09PM 0:00.02
postgres: archiver process
postgres 633 0.0 -0.0 32864 164 ?? S 1:09PM 0:00.02
postgres: stats buffer process
postgres 634 0.0 -0.0 31888 284 ?? S 1:09PM 0:00.03
postgres: stats collector process

We are able to connect to the instance (using psql), but cannot shut
down or restart the instance using pg_ctl (it just reports that the
server is not running). We are running PostgreSQL version 8.0.0 and
Mac OS X 10.3.9. Can anyone tell us what's going on?

Thanks!
Tim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phong & Ronni Bounmixay 2005-11-28 20:18:41 sub select as a data column
Previous Message Marek Lewczuk 2005-11-28 18:56:35 intarray index