DevHeads.net

postgresql Service Blind

Hi folks.

postgresql fresh install, roles, users, databases, all done. I can log in after I SSH to the box.

I entered my user (myself) in pg_hba.conf:

host all rich 192.168.1.4 255.255.255.255 md5

When I nmap the CentOS box, I can’t see that port open. I’ve turned off SELinux, so I’m not sure why I can’t see the open port 5432.

What am I missing? It has to be something I’ve overlooked.

- SELinux off
- firewall poked holes port 5432
- service running

Cheers, Bee

Comments

Re: postgresql Service Blind

By Pete Biggs at 09/13/2018 - 06:37

listen_address = '*'

by default it only listens on localhost. It's documented in the file
and is easily googleable.

Use 'netstat -nlt' (or whatever the modern equivalent is) to see what's
listening on which address.

P.