Re: BUG #1951: Multiple instances of postgres.exe running - Mailing list pgsql-bugs

From Magnus Hagander
Subject Re: BUG #1951: Multiple instances of postgres.exe running
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C7AA7@algol.sollentuna.se
Whole thread Raw
In response to BUG #1951: Multiple instances of postgres.exe running  ("Terry Leffler" <jt@jtleffler.com>)
List pgsql-bugs
> Bug reference:      1951
> Logged by:          Terry Leffler
> Email address:      jt@jtleffler.com
> PostgreSQL version: 8.04
> Operating system:   windows 2000
> Description:        Multiple instances of postgres.exe running
> Details:=20
>=20
> Hi,=20
>=20
> I have seen multiple instances of postgres.exe running in my=20
> task manager.
> Right now it is 6 separate instances. I can reboot and=20
> (postgresql starts as a service) I will see 4 instances of=20
> postgres.exe.
>=20
> I can do "SELECT * FROM pg_stat_activity" and I receive:
>=20
> 1;"template1";1720;1;"postgres";"<command string not enabled>";""
> 17262;"TurningRocks";584;1;"postgres";"<command string not=20
> enabled>";""
> 17262;"TurningRocks";808;1;"postgres";"<command string not=20
> 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

pgsql-bugs by date:

Previous
From: "incheol yang"
Date:
Subject: BUG #1952: Doc 32.4 example
Next
From: Richard Huxton
Date:
Subject: Re: BUG #1954: Bug in to_date('09-10-2005', 'dd-mm-yyyy')