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