| From: | Barry Lind <blind(at)xythos(dot)com> | 
|---|---|
| To: | pgsql-hackers-win32(at)postgresql(dot)org | 
| Subject: | shutdown problems on win32 | 
| Date: | 2004-03-17 05:42:44 | 
| Message-ID: | 4057E554.6040807@xythos.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers-win32 | 
I mentioned this a few days ago, but I have a little more information to 
add.
The problem I reported was that I am having difficultly shutting down 
the postmaster in the current win32 code base.  I start the postmaster 
in a windows console and then am using ctrl-C to shut it down (is there 
some other way to do this until the services code is added?).  What I am 
seeing is that sometimes the postmaster doesn't respond to the ctrl-C 
until much later.
The additional info I have is as follows:
1) startup the postmaster
2) ctrl-c it shuts down as expected
the case that doesn't work:
1) startup the postmaster
2) connect via psql
3) exit from psql
4) ctrl-c the postmaster it doesn't shutdown
5) connect via psql again (successfully)
6) exit psql
7) connect via psql again (this time connection will fail)
8) postmaster finally shutsdown
Here is what I have noticed that is strange:  when the postmaster starts 
up I see three processes (the one postmaster process and two postgres 
processes (stats collector processes I assume) which seems completely 
normal.  However when I connect via psql I now see 5 processes, the one 
postmaster and four postgres processes.  Whereas on linux I only see 4 
(1 + 3).  Then when I exit psql only one of the two extra processes goes 
away.  So after connecting via psql and exiting there is an extra 
postgres process hanging around.  This doesn't happen on linux.  Is this 
expected behavior?  Could this be contributing to my shutdown problems?
thanks,
--Barry
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Claudio Natoli | 2004-03-17 06:04:21 | Re: shutdown problems on win32 | 
| Previous Message | Bruce Momjian | 2004-03-16 15:50:34 | Re: win32 open patch for held unlink |