5432 PostgreSQLPostgreSQL database server.
App-to-database. Bind internally; enforce TLS and pg_hba rules.
| Transport | Status | Meaning |
|---|---|---|
| TCP | Yes | Assigned by IANA and standardized, specified, or widely used on this port. |
| UDP | Assigned | Assigned by IANA, but not standardized, specified, or widely used on this port. |
| SCTP | — | Not applicable for this transport. |
| DCCP | — | Not applicable for this transport. |
Registered (1024–49151). Assigned by IANA on request; usable without elevated privileges on most systems.
Browse all ports →
Copy-ready inbound rules for the active transports. Replace every <source> placeholder with the specific host, subnet, or CIDR that should reach this port.
sudo ufw allow proto tcp from <source> to any port 5432Allow TCP 5432 (PostgreSQL). Replace <source> with the network/host that should reach it.
sudo firewall-cmd --permanent --add-rich-rule='rule family="ipv4" source address="<source>" port port="5432" protocol="tcp" accept'Allow TCP 5432 (PostgreSQL) from <source>. Run 'firewall-cmd --reload' afterwards.
nft add rule inet filter input ip saddr <source> tcp dport 5432 acceptAllow TCP 5432 (PostgreSQL). Assumes table 'inet filter' with an 'input' chain.
sudo iptables -A INPUT -p tcp -s <source> --dport 5432 -j ACCEPTAllow TCP 5432 (PostgreSQL). Persist with iptables-save/netfilter-persistent.
az network nsg rule create -g <resource-group> --nsg-name <nsg> -n Allow-postgresql-5432 --priority 1000 --access Allow --direction Inbound --protocol TCP --source-address-prefixes <source> --destination-port-ranges 5432Inbound rule for 5432 (PostgreSQL). Set <source> to a CIDR; lower priority number = higher precedence.
aws ec2 authorize-security-group-ingress --group-id <sg-id> --ip-permissions IpProtocol=tcp,FromPort=5432,ToPort=5432,IpRanges="[{CidrIp=<source-cidr>}]"Inbound TCP 5432 (PostgreSQL). Replace <source-cidr> (e.g. 10.0.0.0/16).
gcloud compute firewall-rules create allow-postgresql-5432 --direction=INGRESS --action=ALLOW --rules=tcp:5432 --source-ranges=<source-cidr> --network=<network>Ingress rule for 5432 (PostgreSQL). Scope with --source-ranges and optionally --target-tags.
netsh advfirewall firewall add rule name="Allow PostgreSQL 5432/TCP" dir=in action=allow protocol=TCP localport=5432 remoteip=<source>Inbound TCP 5432 (PostgreSQL). Set remoteip to a host/subnet; 'any' is discouraged.
New-NetFirewallRule -DisplayName "Allow PostgreSQL 5432/TCP" -Direction Inbound -Action Allow -Protocol TCP -LocalPort 5432 -RemoteAddress <source>Inbound TCP 5432 (PostgreSQL). Replace <source> with a host or subnet.
Rules are generated only for transports marked active for this port. They default to an inbound allow with an explicit source placeholder — never any. Review direction, scope, and rule precedence before applying in production.