...

Hi all,

Here is the first draft for the spec of postmaster starting/stopping
tool. I have named it as "pg_ctl."

o pg_ctl [-w] start

start up postmaster. If -w is specified, it will wait for the database
up and running.  Options for postmaster should be placed in
$PGDATA/postmaster.conf.

Note: pg_ctl assumes that postmaster writes its pid into
$PGDATA/postmaster.pid.

o pg_ctl [-w][-s|-f|-i] stop

stop postmaster. If -w is specified, it will wait for the database
shutting down.

Shutdown mode can be one of:
-s: smart shutdown (default)-f: fast shutdown-i: immediate shutdown

o pg_ctl [-w][-s|-f|-i] restart

just stop and start postmaster.

o pg_ctl status

report the status of postmaster. It would be nice if it could report,
for example, the number of backends running (and their pids) etc. For
this purpose I propose followings:

(1) Add another protocol STATUS_REQUEST_CODE to libpq/pqcomm.h.

(2) Add code to process the protocol in
postmaster/postmaster.c:readStartupPacket().

Comments, suggestions are welcome.
--
Tatsuo Ishii