How about adding pg_ctl [-w] restart?
It will automatically stop and start the database again.
Chai
Tatsuo Ishii wrote:
>
> 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
>
> ************
