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
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?