How to shutdown PostgreSQL in WinXP
От | David Flory |
---|---|
Тема | How to shutdown PostgreSQL in WinXP |
Дата | |
Msg-id | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAA48bIjzpX0xGAzADAT0HvxsKAAAAQAAAAYa1TwNpmh0iLH5M2Rhl+CQEAAAAA@fdu.edu обсуждение исходный текст |
Список | 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@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-----
В списке pgsql-hackers-win32 по дате отправления: