Port / TCP
5432PostgreSQL
The default PostgreSQL listener for client queries, replication, and administrative connections.
If it is internet-facing: Finding 5432 open to the internet is a finding in its own right — it warrants an explanation, not just a rule.
Exposure
Trusted network only
Transport
Encryption optional
Risk if public
High
Exposure verdict
Port 5432 belongs on a trusted internal network. If a perimeter scan finds it answering, treat that as a firewall defect rather than a configuration preference.
Encryption is available but negotiated or configured rather than guaranteed. A client that does not insist on it will silently fall back to plaintext.
Registered with IANA on request, but bindable by any unprivileged user. Registration records intent — it does not reserve the port, so collisions between products are common.
Grouped with the other databases & caches ports so a rule written for one can be checked against its neighbours.
What actually goes wrong
2 notes- listen_addresses and pg_hba.conf are two separate gates — a permissive host-based rule with a public bind is an open database.
- Require scram-sha-256 authentication and TLS for any connection that leaves the host.
Recommended firewall rule
Allow only from 10.0.0.0/8, drop the rest
Swap in the CIDR your administrators or application tier actually come from — the point is that the default answer is no.
ufw
sudo ufw allow from 10.0.0.0/8 to any port 5432 proto tcpiptables
sudo iptables -A INPUT -p tcp -s 10.0.0.0/8 --dport 5432 -j ACCEPT
sudo iptables -A INPUT -p tcp --dport 5432 -j DROPIf you do need it open to everyone
sudo ufw allow 5432/tcpWrite down why. An unexplained allow rule outlives the person who added it, and the next reviewer has no way to tell a deliberate exception from an accident.
Check what is really there
Listening locally
sudo ss -tlpn 'sport = :5432'The bind address is the answer that matters: 127.0.0.1 is local-only, 0.0.0.0 and :: mean every interface.
Listening (macOS)
sudo lsof -nP -iTCP:5432 -sTCP:LISTENmacOS ships lsof rather than ss; this names the owning process and user.
From outside
nmap -sV -Pn -p 5432 <host>A version probe confirms whether PostgreSQL is actually what answers, rather than trusting the number. Only scan hosts you are authorised to test.
Reachability
nc -vz <host> 5432The quick yes/no when you only need to know whether a path exists through the firewall.
The safer path
no port changeChange the configuration, not the port
Tunnel over SSH or use a private network rather than exposing the listener.
The fix here lives in the service configuration rather than in a different port assignment.