Re: unable starting / stopping postgresql with pgAdmin III on OS X
От | Georges Moes |
---|---|
Тема | Re: unable starting / stopping postgresql with pgAdmin III on OS X |
Дата | |
Msg-id | 4B391AFA.1030703@web.de обсуждение исходный текст |
Ответ на | Re: unable starting / stopping postgresql with pgAdmin III on OS X (Guillaume Lelarge <guillaume@lelarge.info>) |
Ответы |
Re: unable starting / stopping postgresql with
pgAdmin III on OS X
|
Список | pgadmin-support |
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. > >
В списке pgadmin-support по дате отправления:
Предыдущее
От: Dave PageДата:
Сообщение: Re: unable starting / stopping postgresql with pgAdmin III on OS X
Следующее
От: Guillaume LelargeДата:
Сообщение: Re: unable starting / stopping postgresql with pgAdmin III on OS X