Port 5432 POSTGRESQL
Port 5432 is the IANA-assigned postgresql port for PostgreSQL Database (TCP / UDP).
What is port 5432 used for?
Port 5432 is assigned to postgresql and uses TCP / UDP. The IANA registry describes the service as “PostgreSQL Database”. It sits in the registered range, the block used by databases, application servers and developer tooling. Port conflicts here are common when several local services start at once.
Ports are the transport-layer address a service listens on. A client that wants to reach postgresql connects to port 5432. A TCP connection is refused when nothing is listening, while a UDP request simply goes unanswered. That is why a port conflict appears whenever two processes try to bind the same number.
Use the commands below to confirm whether port 5432 is actually in use before you change firewall rules. Blocking the port stops new inbound traffic at the firewall, but it does not stop a local process from listening, and it does not remove the service from the machine.
Source: IANA Service Name and Transport Protocol Port Number Registry. Registered assignee: [Tom_Lane].
Check and block port 5432
Copy-ready commands for the protocols assigned to this port. Run the check first, then block only what should not be reachable.
Check on Linux
sudo ss -tlpn 'sport = :5432'
sudo ss -ulpn 'sport = :5432'Check on Windows
Get-NetTCPConnection -LocalPort 5432 -State Listen -ErrorAction SilentlyContinue
Get-NetUDPEndpoint -LocalPort 5432 -ErrorAction SilentlyContinueBlock with UFW
sudo ufw deny 5432/tcp
sudo ufw deny 5432/udpBlock with iptables
sudo iptables -A INPUT -p tcp --dport 5432 -j DROP
sudo iptables -A INPUT -p udp --dport 5432 -j DROPThese commands are examples for a typical host. Check the listener before you change firewall rules, and persist iptables rules with iptables-save or netfilter-persistent. On Windows, use Windows Defender Firewall or New-NetFirewallRule for persistent blocks. The iptables rules here cover IPv4; mirror them with ip6tables if IPv6 is enabled.
Is port 5432 safe to expose?
PostgreSQL should be limited to application networks. Enforce strong authentication, TLS and a deny-by-default firewall policy. Expose this port only when the service is actually needed. Keep it patched, prefer an encrypted alternative, and limit source addresses with a firewall allowlist.
Where port 5432 is usually used
Most traffic on port 5432 falls into these scenarios. The demo below is a safe way to confirm the listener before you change anything.
- Application servers opening pooled connections to the database on port 5432.
- Migrations, backups and reporting jobs run from a trusted bastion host.
- Local Docker or test environments that publish the database on the host.
Open a PostgreSQL session
Connect with a least-privilege role; psql prompts for the password when needed.
psql "host=127.0.0.1 port=5432 dbname=postgres"Common problems with port 5432
Connection refused or timed out
Refused usually means the host is reachable but nothing is listening on port 5432. A timeout more often means a firewall drop, a wrong host or a service bound to a different interface.
Port already in use
Find the process holding the port with sudo ss -tlpn 'sport = :5432' or sudo lsof -i :5432. Stop that process or configure it to bind another port; killing it without identifying it can take down a production service.
Firewall rule did not survive a reboot
UFW and Windows Firewall keep rules across restarts. Raw iptables rules do not: save them with iptables-save or the netfilter-persistent package, and re-apply after upgrades that reset the ruleset.
The port is blocked but still reachable
A firewall rule filters inbound traffic; it does not close the listener. Confirm with the check command above and bind the service to 127.0.0.1 when only local clients need it.
Port 5432 at a glance
| Port number | 5432 |
|---|---|
| Service name | postgresql |
| Transport protocol | TCP / UDP |
| Category | Databases |
| Range | Registered port (1024–10000) |
| Risk level | Medium |
| Registered assignee | [Tom_Lane] |
| Registry description | PostgreSQL Database |
| Source | IANA Service Name and Transport Protocol Port Number Registry |
Frequently asked questions
What is port 5432 used for?
Port 5432 (POSTGRESQL) uses TCP / UDP. PostgreSQL Database.
How do I check if port 5432 is open?
On Linux run `sudo ss -tlpn 'sport = :5432'` and `sudo ss -ulpn 'sport = :5432'`. On Windows run `Get-NetTCPConnection -LocalPort 5432 -State Listen -ErrorAction SilentlyContinue` and `Get-NetUDPEndpoint -LocalPort 5432 -ErrorAction SilentlyContinue` in PowerShell. If the port is open, the output shows a process listening on port 5432; empty output usually means nothing is bound to it.
How do I block port 5432?
With UFW run `sudo ufw deny 5432/tcp` and `sudo ufw deny 5432/udp`. With iptables run `sudo iptables -A INPUT -p tcp --dport 5432 -j DROP` and `sudo iptables -A INPUT -p udp --dport 5432 -j DROP`. Persist the iptables rules with your distribution's netfilter-persistent or iptables-save tooling so they survive a reboot.
Is port 5432 safe to expose?
PostgreSQL should be limited to application networks. Enforce strong authentication, TLS and a deny-by-default firewall policy. Nevertheless, expose this port only when the service is actually needed. Keep it patched, prefer an encrypted alternative, and limit source addresses with a firewall allowlist.
Related ports
- Port 5429 · baseBilling and Accounting System Exchange
- Port 5434 · sgi-arraydSGI Array Services Daemon
- Port 5029 · infobrightInfobright Database Server
- Port 5629 · symantec-sfdbSymantec Storage Foundation for Database
- Port 4999 · hfcs-managerHFSQL Client/Server Database Engine Manager
- Port 5984 · couchdbCouchDB
Primary data: IANA Service Name and Transport Protocol Port Number Registry.
Last reviewed 2026-10-30 · Methodology · About · Privacy