dbTalk Databases Forums  

[BUGS] BUG #1951: Multiple instances of postgres.exe running

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1951: Multiple instances of postgres.exe running in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Terry Leffler
 
Posts: n/a

Default [BUGS] BUG #1951: Multiple instances of postgres.exe running - 10-11-2005 , 11:07 AM







The following bug has been logged online:

Bug reference: 1951
Logged by: Terry Leffler
Email address: jt (AT) jtleffler (DOT) 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

Reply With Quote
  #2  
Old   
Magnus Hagander
 
Posts: n/a

Default Re: [BUGS] BUG #1951: Multiple instances of postgres.exe running - 10-11-2005 , 11:23 AM






Quote:
Bug reference: 1951
Logged by: Terry Leffler
Email address: jt (AT) jtleffler (DOT) 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

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

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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.