linux : Finding the postgres idle process originator

Question

Actually , I am running four daemon program. It makes postgres connection, and it disconnects once through with the stuffs. But When I am putting ps aux , there are lot of postgres idle process being run in my system. I just want to know , originator of the each idle postres process. So, that I could find out which process does not close postgres connection properly.

Thanks in Advance .

Answer 1

Use following command

netstat -ntp

It will show the process id and process name of postgres connector creator.