#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Posts
    2
    Rep Power
    0

    Processes related to Postgres


    hi,
    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.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    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.
    Attached Images
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Posts
    2
    Rep Power
    0
    Thanks Shammat.
    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.
    Cheers anyway.

IMN logo majestic logo threadwatch logo seochat tools logo