Configuration parameter

port — PostgreSQL Configuration Parameter

Category Connections Default 5432 Unit boolean / enum / numeric Change scope Restart required

TCP port the server listens on.

At a glance

Property Value
Parameter port
Category Connections
Default 5432
Value type boolean / enum / numeric
Change scope Restart required

What it does

The TCP port number the server uses for incoming connections. All clients must connect to this port.

How to apply a change

Requires a full server restart (postmaster context). Set it in postgresql.conf and restart PostgreSQL.

Inspect the current value and source with SHOW port; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'port';.

Tuning guidance

Change only to run multiple instances on one host or to obscure the default. Update clients, poolers, and monitoring when you do.

Reference

PostgreSQL documentation — Connections configuration.

Was this helpful?

← All configuration parameters