Обсуждение: BUG #1951: Multiple instances of postgres.exe running

The following bug has been logged online:

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:

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>";""

Thanks

> 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