BUG #1951: Multiple instances of postgres.exe running

[Terry Leffler]

The following bug has been logged online:

Bug reference: 1951
Logged by: Terry Leffler
Email address: j...@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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Magnus Hagander]

> Bug reference: 1951
> Logged by: Terry Leffler
> Email address: j...@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>";""

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq