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.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
