Skip site navigation (1) Skip section navigation (2)

Re: pgAdmin 1.12.0 (Mac OS X 10.5) Start Service instability

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 (view raw or flat)
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

In response to

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2010-10-05 07:50:19
Subject: Re: pgAdmin III 1.12 strange behaviour in text editing
Previous:From: Ernst W. WinterDate: 2010-10-05 07:02:26
Subject: update with FreeBSD PostgreSQL 9.0 and pgadmin3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group