Architecting, installing and maintaining your SAS environment

Postgress.exe processes

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Postgress.exe processes

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-


Accepted Solutions
Solution
‎03-07-2017 03:31 PM
SAS Employee
Posts: 101

Re: Postgress.exe processes

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/...

View solution in original post


All Replies
Solution
‎03-07-2017 03:31 PM
SAS Employee
Posts: 101

Re: Postgress.exe processes

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/...

New Contributor
Posts: 2

Re: Postgress.exe processes

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

 

Thanks!

Trusted Advisor
Posts: 1,141

Re: Postgress.exe processes

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 235 views
  • 4 likes
  • 3 in conversation