From: | "David Flory" <flory(at)fdu(dot)edu> |
---|---|
To: | <pgsql-hackers-win32(at)postgresql(dot)org> |
Subject: | How to shutdown PostgreSQL in WinXP |
Date: | 2004-04-01 04:48:40 |
Message-ID: | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAA48bIjzpX0xGAzADAT0HvxsKAAAAQAAAAYa1TwNpmh0iLH5M2Rhl+CQEAAAAA@fdu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 |
-----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(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
Comment: 201-692-7064
iQA/AwUBQGufKFe2/rcN3lp8EQLkEwCfeaDUVJJxYv9jdYX81oNwaioIkOEAoJat
3thn5C0jY9TvNzh/56POmFUs
=Sv4X
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Claudio Natoli | 2004-04-01 04:57:52 | Re: How to shutdown PostgreSQL in WinXP |
Previous Message | Magnus Hagander | 2004-03-31 11:47:24 | Re: performance error |