Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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-----


pgsql-hackers-win32 by date

Next:From: Claudio NatoliDate: 2004-04-01 04:57:52
Subject: Re: How to shutdown PostgreSQL in WinXP
Previous:From: Magnus HaganderDate: 2004-03-31 11:47:24
Subject: Re: performance error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group