-----BEGIN PGP SIGNED MESSAGE-----
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.
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
Email: flory(at)fdu(dot)edu (regular email)
Pager: flory(at)vText(dot)com (subj + text < 150 char)
http://TheFlorys.org/David.Flory/ <== My PGP key is here
-----BEGIN PGP SIGNATURE-----
Version: PGP 8.0.3
-----END PGP SIGNATURE-----
pgsql-hackers-win32 by date
|Next:||From: Claudio Natoli||Date: 2004-04-01 04:57:52|
|Subject: Re: How to shutdown PostgreSQL in WinXP|
|Previous:||From: Magnus Hagander||Date: 2004-03-31 11:47:24|
|Subject: Re: performance error|