-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I have successfully compiled and installed the postgres-snapshot
development distribution on a Windows XP SP1 system using the
MinGW/Msys environment. It runs and I can use psql to connect. My
question is how do I (gracefully) stop it?
I come from an Oracle environment where one would login AS SYSDBA or
INTERNAL and issue a SHUTDOWN command, NORMAL (smart) or IMMEDIATE
(fast) or ABORT (immediate). In WinXP one can also stop the service.
All of these (except ABORT) produces a graceful shutdown.
It looks as if the pg_ctl shell should produce the result except that
it doesn't work. There seems to be a problem with the correct PID and
with sending a signal in a Win32 environment. I can stop postmaster
and the postgres processes using kill or task manager but neither is
a "smart" or "fast" shutdown.
Clearly, I am a novice on PostgreSQL and I hope I haven't overlooked
an obvious piece of documentation. I also realize that we are still
very much in development. A kludge or work-around would be fine. If I
have missed an obvious solution, I apologize to the list.
Tia, David
- --------------------------------------------------
David Flory, Ph.D.
Professor of Physics & Director
School of Natural Sciences
Fairleigh Dickinson University
1000 River Road, Mail Stop H-DH4-03
Teaneck, New Jersey 07666
Office: Dickinson Hall Room 4460
Voice: 201-692-7064
Email: flory@fdu.edu (regular email)
Pager: flory@vText.com (subj + text < 150 char)
http://TheFlorys.org/David.Flory/ <== My PGP key is here
-----BEGIN PGP SIGNATURE-----
Version: PGP 8.0.3
Comment: 201-692-7064
iQA/AwUBQGufKFe2/rcN3lp8EQLkEwCfeaDUVJJxYv9jdYX81oNwaioIkOEAoJat
3thn5C0jY9TvNzh/56POmFUs
=Sv4X
-----END PGP SIGNATURE-----