topic Re: postgres HP-UX 11.31 what's the purpose in Operating System - HP-UX

postgres HP-UX 11.31 what's the purpose

jason_lee — Thu, 29 Oct 2009 03:32:55 GMT

Hi,
What's the purpose of postgres process? Can we shut it down? What's the impact? We have HP-UX 11.31 IA-64.

Re: postgres HP-UX 11.31 what's the purpose

Duncan Edmonstone — Thu, 29 Oct 2009 06:35:19 GMT

Is it running as user sfmdb?

If so then no, I wouldn't stop it as it provides the backend data store for the system fault management database - It's pretty lightweight and shouldn't consume any significant resources... learn about SFM here:

http://docs.hp.com/en/5900-0167/5900-0167.pdf

HTH

Duncan

Re: postgres HP-UX 11.31 what's the purpose

jason_lee — Thu, 29 Oct 2009 09:08:48 GMT

Duncan thanks for the reply. As we are performing security hardening on the server, we want to know/close ports that are not critical. For those that we want it to remain open, we need to justify.

Re: postgres HP-UX 11.31 what's the purpose

Michael Leu — Thu, 29 Oct 2009 17:44:51 GMT

Thanks for pointing this out. I think it's really stupid that a OS-internal databases is listening on a port that can be accessed from outside.

# lsof -i | grep sfmdb
postgres 14064 sfmdb 4u IPv6 0t0 TCP *:10864 (LISTEN)
postgres 14064 sfmdb 5u IPv4 0t0 TCP *:10864 (LISTEN)

Is there any way to turn this off?

Re: postgres HP-UX 11.31 what's the purpose

Steven E. Protter — Thu, 29 Oct 2009 17:53:02 GMT

Shalom,

postgress generally works with local httpd servers and doesn't need to listen on a port. Check configuration if it is. It may not need to be unless an EXTERNAL server is accessing the postgress database data.

SEP