Lists: | pgsql-hackers-win32 |
---|
From: | Claudio Natoli <claudio(dot)natoli(at)memetrics(dot)com> |
---|---|
To: | 'Barry Lind' <blind(at)xythos(dot)com>, pgsql-hackers-win32(at)postgresql(dot)org |
Subject: | Re: shutdown problems on win32 |
Date: | 2004-03-17 06:04:21 |
Message-ID: | A02DEC4D1073D611BAE8525405FCCE2B55F395@harris.memetrics.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers-win32 |
> 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
> [snip]
>
> 8) postmaster finally shutsdown
This is most definitely due to the pgstat select/APC bug. See
http://archives.postgresql.org/pgsql-hackers-win32/2004-03/msg00041.php
or
http://archives.postgresql.org/pgsql-hackers/2004-03/msg00246.php
With CVS sources I can reproduce the described behaviour. With a local patch
for the above bug, the problem goes away.
> 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.
That is strange. I've got it too. Looks like the extra process is the
BackgroundWriter, and it is looping forever in BufferBackgroundWriter. I'll
look into it.
> linux. Is this expected behavior? Could this be contributing to my
shutdown
> problems?
No, on both counts.
Cheers,
Claudio
---
Certain disclaimers and policies apply to all email sent from Memetrics.
For the full text of these disclaimers and policies see
<a
href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em
ailpolicy.html</a>
From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Claudio Natoli <claudio(dot)natoli(at)memetrics(dot)com> |
Cc: | "'Barry Lind'" <blind(at)xythos(dot)com>, pgsql-hackers-win32(at)postgresql(dot)org |
Subject: | Re: shutdown problems on win32 |
Date: | 2004-03-17 13:18:15 |
Message-ID: | 200403171318.i2HDIF621932@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers-win32 |
Claudio Natoli wrote:
>
>
> > 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
> > [snip]
> >
> > 8) postmaster finally shutsdown
>
> This is most definitely due to the pgstat select/APC bug. See
> http://archives.postgresql.org/pgsql-hackers-win32/2004-03/msg00041.php
> or
> http://archives.postgresql.org/pgsql-hackers/2004-03/msg00246.php
>
> With CVS sources I can reproduce the described behaviour. With a local patch
> for the above bug, the problem goes away.
Magnus is still researching the APC issue.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073