Access Instance by Port

1. Identify Instance Port

pg_lsclusters

root@db-psql-prd-01:~# pg_lsclusters
Ver Cluster Port Status Owner    Data directory              Log file
13  main    5432 online postgres /var/lib/postgresql/13/main /var/log/postgresql/postgresql-13-main.log
15  main    5433 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log
18  main    5434 online postgres /var/lib/postgresql/18/main /var/log/postgresql/postgresql-18-main.log

2. Open Connection to specific Instance using Port

Host-to-Host Connections

psql -h <REMOTE HOST> -p <REMOTE PORT> -U <DB_USER> <DB_NAME>

Localhost Connections using local-only Authentication

sudo -u postgres psql -P <PORT> [...]