On Sun, 12 Dec 2004 19:55:10 +0100, Magnus Hagander <mha@sollentuna.net> wrote:
>
>
> >> >(without forcibly
> >> >stopping / starting the server)?
> >>
> >> You can either use "pg_ctl kill", or you can send a "pause"
> >command to
> >> the service.
> >
> >"pause"? Well, I suppose it's more humane than kill ;-).
> >I get an error about the server not returning an error which
> >might be an internal Windows error or an internal service
> >error, but it seems to work.
>
> Yeah, that's normal.
I like the "command line" version as well:
C:\Program Files\PostgreSQL\8.0.0-rc1\bin>net pause pgsql-8.0.0-rc1
The PostgreSQL Database Server 8.0.0-rc1 service failed to pause.
More help is available by typing NET HELPMSG 3539.
C:\Program Files\PostgreSQL\8.0.0-rc1\bin>net helpmsg 3539
The *** service failed to pause.
(trying to think what three-letter word is meant here... ;-)
Seriously, would this not be a good FAQ item too?
Thanks for all the feedback.
Ian Barwick