Solved

Windows 2003 std with multiple instances of Postgres.exe running

Posted on 2011-09-09
7
1,174 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

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…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
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.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

838 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