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