Port reference › Databases
Port 5432 · PostgreSQL
PostgreSQL
TCP Databases Exposure risk: High
What is port 5432 used for?
Default PostgreSQL port.
Registered port (1024-49151): the range used by ordinary applications.
Security notes
Narrow allowed networks in pg_hba.conf and set listen_addresses carefully. Avoid direct internet exposure.
Allow port 5432 through the firewall
This port is risky to expose, so the commands below allow only the IPs you specify.
# Replace 203.0.113.10/32 with the IP or network you want to allow
sudo ufw allow from 203.0.113.10/32 to any port 5432 proto tcp
sudo ufw status # Replace 203.0.113.10/32 with the IP or network you want to allow
sudo firewall-cmd --permanent --add-rich-rule='rule family="ipv4" source address="203.0.113.10/32" port port="5432" protocol="tcp" accept'
sudo firewall-cmd --reload # Replace 203.0.113.10/32 with the IP or network you want to allow
sudo iptables -A INPUT -p tcp -s 203.0.113.10/32 --dport 5432 -j ACCEPT # Replace 203.0.113.10/32 with the IP or network you want to allow
New-NetFirewallRule -DisplayName "Allow TCP 5432" -Direction Inbound -Protocol TCP -LocalPort 5432 -RemoteAddress 203.0.113.10/32 -Action Allow # Replace sg-0123456789abcdef0 with your security group ID
aws ec2 authorize-security-group-ingress --group-id sg-0123456789abcdef0 --protocol tcp --port 5432 --cidr 203.0.113.10/32 Check whether port 5432 is open
sudo ss -tlpn | grep ':5432 ' netstat -ano | findstr :5432 nc -zv SERVER 5432
# Windows
Test-NetConnection SERVER -Port 5432 sudo lsof -i :5432