October 11th, 2012, 11:31 AM
Processes related to Postgres
I have found there are 8 processes running as postgres.exe (Postgres 9.0) and one of them is hidden. Is it supposed to be like that?? or the hidden one is a malware and I should delete it??
Thanks in Advance.
October 11th, 2012, 12:13 PM
I don't know what "hidden" should mean.
After a startup you have the following processes running (all named postgres)
- postmaster (controls the others)
- logger process
- checkpoint writer
- writer process
- stats collector
- wal writer
- autovacuum launcher
The autovacuum launcher will actually start another postgres process in regular intervals (the one which will do the actual vacuum work)
If you are on windows you'll see an additional process pg_ctl that started all of them.
And then you'll have one process for each connection that is made to the database.
If you are on linux you will see all these names in the output of the ps command.
I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
Tips on how to ask better questions:
October 11th, 2012, 02:00 PM
Recently as my PC is getting slow so I have used Process Hacker to analyse my memory usage and if any malware is eating up my memories. I have read in some articles that processes that hide themselves (Hidden Processes) are usually potential threat and eating up memories.
And I found there are 8 processes which run in my pc (Postgres\9.0\bin\postgres.exe) and one of them is hidden (marked as red). So I am quite suspicious about this one was thinking to terminate it. but I don't know if this will affect postgres as I use it quite often. As I am not sure as it is used by postgres or a spyware in disguise.
Hence I have posted it in case people who use postgres can check it out whether it is normal or not.