Re: unable starting / stopping postgresql with pgAdmin III on OS X

[Georges Moes <g(dot)moes(at)web(dot)de>]

I just refered to the help-file of pgAdmin III.
Under 'Connect to server' I've found the following description:

If pgAdmin is running on a Windows machine, it can control the 
postmaster service if you have enough access rights. Enter the name of 
the service. In case of a remote server, it must be prepended by the 
machine name (e.g. PSE1\pgsql-8.0). pgAdmin will automatically discover 
services running on your local machine.

If pgAdmin is running on a Unix machine, it can control processes 
running on the local machine if you have enough access rights. Enter a 
full path and needed options to access the pg_ctl program. When 
executing service control functions, pgAdmin will append 
status/start/stop keywords to this. Example:
sudo /usr/local/pgsql/bin/pg_ctl -D /data/pgsql

It seems as if I misunderstood that?

If OS X doesn't support that, it would be nice to introduce that in the 
future.


Thanks

Georges Moes


Am 28.12.09 21:37, schrieb Guillaume Lelarge:
> Le 28/12/2009 21:15, Georges Moes a écrit :
> > I've tried to activate the start / stop option for the postgresql
> > service in pgAdmin III on my Snow Leopard Installation. The PostgreSQL
> > Version is 8.4.
> > I can start the service via terminal with:
> > geo-mbp:~ gm$ sudo su postgres
> > bash-3.2$ /Library/PostgreSQL/8.4/bin/pg_ctl -D
> > /Library/PostgreSQL/8.4/data start
> > server starting
> > bash-3.2$ /Library/PostgreSQL/8.4/bin/pg_ctl -D
> > /Library/PostgreSQL/8.4/data stop -m fast
> > waiting for server to shut down.... done
> > server stopped
> >
> > How can i use these commands in the GUI of pgAdmin III to start and stop
> > the service? I've tried the following and a few other things with no
> > success in the Properties pane under service:
> >
> > sudo su postgres -c /Library/PostgreSQL/8.4/bin/pg_ctl -D
> > /Library/PostgreSQL/8.4/data
> >
> >
> > What's wrong with that????
>
> The service field is only useful on Windows. What you want is not a
> feature pgAdmin has on other platforms.




Am 28.12.09 21:37, schrieb Guillaume Lelarge:
> Le 28/12/2009 21:15, Georges Moes a écrit :
> > I've tried to activate the start / stop option for the postgresql
> > service in pgAdmin III on my Snow Leopard Installation. The PostgreSQL
> > Version is 8.4.
> > I can start the service via terminal with:
> > geo-mbp:~ gm$ sudo su postgres
> > bash-3.2$ /Library/PostgreSQL/8.4/bin/pg_ctl -D
> > /Library/PostgreSQL/8.4/data start
> > server starting
> > bash-3.2$ /Library/PostgreSQL/8.4/bin/pg_ctl -D
> > /Library/PostgreSQL/8.4/data stop -m fast
> > waiting for server to shut down.... done
> > server stopped
> >
> > How can i use these commands in the GUI of pgAdmin III to start and stop
> > the service? I've tried the following and a few other things with no
> > success in the Properties pane under service:
> >
> > sudo su postgres -c /Library/PostgreSQL/8.4/bin/pg_ctl -D
> > /Library/PostgreSQL/8.4/data
> >
> >
> > What's wrong with that????
>
> The service field is only useful on Windows. What you want is not a
> feature pgAdmin has on other platforms.