topic Postgress.exe processes in Administration and Deployment

Postgress.exe processes

Laura_NCEMC — Tue, 07 Mar 2017 19:10:15 GMT

I have over 90 postgres.exe processes running on my SAS box, running from the SASWebInfrastructurePlatformDataServer\9.4\bin folder. Can anyone help me understand what they are used for and why there would be so many?

Thanks-

Re: Postgress.exe processes

dpage — Tue, 07 Mar 2017 19:53:34 GMT

It's the way postgres works, every open connection gets a separate process. There was a slightly different question, but with the same root cause a little while ago.

https://communities.sas.com/t5/Administration-and-Deployment/PostgreSQLserver-connections-left-open/m-p/334427

Re: Postgress.exe processes

Laura_NCEMC — Tue, 07 Mar 2017 20:19:20 GMT

Ahh, thank you. I'll see about the shut down of the web application server to see if they go away.

Thanks!

Re: Postgress.exe processes

JuanS_OCS — Tue, 07 Mar 2017 21:32:11 GMT

Excellent question @Laura_NCEMC, and thanks @dpage for the answer. Lately I am experiencing this is becoming a recurrent question.