Re: BUG #1951: Multiple instances of postgres.exe running

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Terry Leffler" <jt(at)jtleffler(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1951: Multiple instances of postgres.exe running
Date: 2005-10-11 16:05:37
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE6C7AA7@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> Bug reference: 1951
> Logged by: Terry Leffler
> Email address: jt(at)jtleffler(dot)com
> PostgreSQL version: 8.04
> Operating system: windows 2000
> Description: Multiple instances of postgres.exe running
> Details:
>
> Hi,
>
> I have seen multiple instances of postgres.exe running in my
> task manager.
> Right now it is 6 separate instances. I can reboot and
> (postgresql starts as a service) I will see 4 instances of
> postgres.exe.
>
> I can do "SELECT * FROM pg_stat_activity" and I receive:
>
> 1;"template1";1720;1;"postgres";"<command string not enabled>";""
> 17262;"TurningRocks";584;1;"postgres";"<command string not
> enabled>";""
> 17262;"TurningRocks";808;1;"postgres";"<command string not
> enabled>";""

This is absolutely normal. The first four are the bgwriter, the logger
and the two stats processees. The other are the backends serving active
connections.

//Magnus

Browse pgsql-bugs by date

  From Date Subject
Next Message Karl O. Pinc 2005-10-11 16:19:09 BUG #1956: Plpgsql top-level DECLARE does not share scope with CREATE FUNCTION
Previous Message Tom Lane 2005-10-11 15:35:45 Re: BUG #1947: Enhancement Request - CONCAT() function