(Oops...originally sent this to Jim, instead of the group)
Thanks for the reply...Yes, we do have ARD installed on the machine,
but I believe the postgres instance that we see running (through ps
auxw | grep postgres) is our server instance (pointed at our data
directory), not the ARD instance. We are still able to connect to
our database using psql (and via JDBC). Does this still seem like it
could be an ARD conflict?
On Nov 28, 2005, at 5:56 PM, Jim C. Nasby wrote:
I've heard from others that OS X's remote desktop equivalent uses an
internal PosgreSQL database in an embedded install that uses the
default
PostgreSQL port. That could be the cause of your trouble...
On Mon, Nov 28, 2005 at 01:24:37PM -0600, Timothy Perrigo wrote:
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
---------------------------(end of
broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
