From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Henning Hraban Ramm <hraban(at)fiee(dot)net> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgAdmin 1.12.0 (Mac OS X 10.5) Start Service instability |
Date: | 2010-10-05 07:40:53 |
Message-ID: | 4CAAD685.4010902@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-10-05 07:50:19 | Re: pgAdmin III 1.12 strange behaviour in text editing |
Previous Message | Ernst W. Winter | 2010-10-05 07:02:26 | update with FreeBSD PostgreSQL 9.0 and pgadmin3 |