Re: pg_ctl

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
> 
> ************