Обсуждение: 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