Thread: pgAdmin 1.12.0 (Mac OS X 10.5) Start Service instability
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. Please let me know if I can help you track down the root cause. Regards, Anton
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)
Le 02/10/2010 08:40, Henning Hraban Ramm a écrit : > 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)? > Just checked on the source. We don't add the "&" at the end of the command. But you shouldn't be blocked by pg_ctl, even without the ampersand at the end. If it is a bug (and I'm not saying it is), it has to be fixed on pg_ctl. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
> Does it help if you add "&" after your command (i.e. sending it >into background)? Thanks for the suggestion, Henning. This does not work--it results in "Starting Service... Failed." I think the reason is that "start|stop|status" are appended to the Service command, so the "&" symbol breaks the resulting full command. Is anyone else running pgAdmin on Mac OS X? Surely I'm either doing something stupid, or other people have the same issue? I can of course get around this issue by using the command line, but it would be nice to get pgAdmin to work correctly. Thanks, Anton