We should add Apple Script support to Postgres.app so that people can automatically start/stop servers.
People asked how to start a server from the command line (eg #832). Previously, our recommendation was to use pg_ctl. However, Postgres.app has started doing more and more things before executing pg_ctl. Some features ("trust" permission dialog, downloadable extensions) are dependent on additional configuration parameters that Postgres.app passes to pg_ctl. This makes it very cumbersome to use pg_ctl directly without losing functionality.
The following features should be a minimum:
- enumerate servers
- get server properties (status, data directory, log file, etc)
- start a server
- stop a server
I assume that for many people a command like tell application Postgres to start/stop the first server would probably be all they need.
There has also been a request to automate the creation of new servers (#714). I believe this would also be a useful addition, and could be implemented in a second step.
We should add Apple Script support to Postgres.app so that people can automatically start/stop servers.
People asked how to start a server from the command line (eg #832). Previously, our recommendation was to use pg_ctl. However, Postgres.app has started doing more and more things before executing pg_ctl. Some features ("trust" permission dialog, downloadable extensions) are dependent on additional configuration parameters that Postgres.app passes to pg_ctl. This makes it very cumbersome to use pg_ctl directly without losing functionality.
The following features should be a minimum:
I assume that for many people a command like
tell application Postgres to start/stop the first serverwould probably be all they need.There has also been a request to automate the creation of new servers (#714). I believe this would also be a useful addition, and could be implemented in a second step.