How to shutdown PostgreSQL in WinXP

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-----

Browse pgsql-hackers-win32 by date

  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