This is a discussion on Re: BUG #1951: Multiple instances of postgres.exe running within the pgsql Bugs forums, part of the PostgreSQL category; --> > Bug reference: 1951 > Logged by: Terry Leffler > Email address: jt@jtleffler.com > PostgreSQL version: 8.04 > Operating ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| > 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>";"" 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 |