Am 2010-10-02 um 02:23 schrieb anton:
I would like to report a strange instability issue when starting
PostgreSQL 9.0
via pgAdmin in Mac OS X 10.5. My Service command is defined as:
sudo -u postgres /Library/PostgreSQL/9.0/bin/pg_ctl -D
/Library/PostgreSQL/9.0/data
Let's say the server is running and I enter pgAdmin. Running?
correctly shows
Yes. If I right-click on the server and then Stop Service, the
server stops
correctly and Running? correctly shows No. If I then right-click
and try to
Start Service, pgAdmin hangs indefinitely. Via Terminal, executing
"sudo -u
postgres /Library/PostgreSQL/9.0/bin/pg_ctl -D /Library/PostgreSQL/
9.0/data
status" shows that the server is running, so pgAdmin did start it
correctly,
even though it's still hanging. Now, when I execute "sudo -u postgres
/Library/PostgreSQL/9.0/bin/pg_ctl -D /Library/PostgreSQL/9.0/data
stop" and go
back to pgAdmin, it actually stops hanging and resumes working
normally! This
is always repeatable.
In summary, Start Service starts the server correctly, but never
gives control
back to pgAdmin, which hangs until the server is stopped.
Does it help if you add "&" after your command (i.e. sending it into
background)?
Greetlings from Lake Constance!
Hraban
---
http://www.fiee.net
https://www.cacert.org (I'm an assurer)
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
