Home / server / Questions / 1025350
Accepted
EM0
Asked: 2020-07-16 07:39:34 +0800 CST

How to find the ports of all running PostgreSQL instances (as a non-root user)

  • 772

I have a monitoring script (running as an unprivileged user) that needs to check all instances of Postgres currently running on the same host (Ubuntu Linux 18.04). Is there an easy way to find all their port numbers?

I was thinking of listing all files matching /var/run/postgresql/.s.PGSQL.* but I'm not sure whether this is reliable or the easiest way.

postgresql

2 Answers

  1. Best Answer

    An easy way with Debian/Ubuntu would be to use pg_lsclusters (as provided by the postgresql-common package). This command lists the clusters with ports, statuses and other information:

    $ pg_lsclusters 
Ver Cluster Port Status Owner    Data directory              Log file
11  main    5433 online postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log
12  main    5432 online postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log

$ ports=$(pg_lsclusters --no-header | awk '{ print $3; }')

$ echo $ports
5433 5432
    • 2

  2. May be something like this:

     ss -xpntl| grep postmaster
    • 1