Solved

Windows 2003 std with multiple instances of Postgres.exe running

Posted on 2011-09-09
7
1,170 Views
Last Modified: 2012-08-14
I just inherited responsibility for another Win2003 server. It’s running very slow and I’m looking to lighten it’s load. In task mgr, I noticed there are five instances of postgres.exe running and I’m assuming it relates to PostgreSQL. Nobody in the company remembers it being installed or needed. How do I deternine what app is using it?

I don’t see PostgreSQL listed in add/remove programs. How do I determine what app uses it?
0
Comment
Question by:Tony Giangreco
  • 3
  • 2
  • 2
7 Comments
 
LVL 13

Accepted Solution

by:
Govvy earned 250 total points
ID: 36510151
Run ProcMon tool to see process, file and registry activity associated with the application
0
 
LVL 39

Expert Comment

by:lcohan
ID: 36512126
There must be a file under C:\Program Files\PostgreSQL in the bin folder of whatever version is running on that windows server and are you sure that in control panel under programs there is no PostgresSQL installed?? What about services on that server?

This can be indeed a postgres database server with multiple instances running that you may not want to terminate/uninstall before you asses the impact/damages
0
 
LVL 25

Author Comment

by:Tony Giangreco
ID: 36512265
Hi Icohan,

Yes I checked for C:\Program Files\PostgreSQL on all drives and looked for the service, but didn't find anything. I do see four to six proceses running with the post. Attatched is a screen print of what I see in task mgr.
PostGres-SP.jpg
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 250 total points
ID: 36512348
Wow!! here's what I use from Microsoft to find out what is running on that PID down to the DLL level and I sugget you use it to.

http://technet.microsoft.com/en-us/sysinternals/bb896653

other than  that netstat command should show all external connections to that box by IP:PORT
0
 
LVL 25

Author Comment

by:Tony Giangreco
ID: 36512354
HI Govvy,

I will install Procmon tomorrow morning when the users are not logged in and see what turns up.
0
 
LVL 13

Expert Comment

by:Govvy
ID: 36512418
Ok
0
 
LVL 25

Author Closing Comment

by:Tony Giangreco
ID: 36519086
It turned out to be Symsntec AV. I'm working on resolving why it runs som many process instances. Thanks for your help.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This may not be a text book method to resolve VSS backup issues but it seemed to have worked on few of the Windows 2003 servers we had issues while performing a Volume Shadow Copy backup. If you have issues while performing a shadow copy backup usin…
Scenerio: You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses.  You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question