vPostgres Error on STIG check

Products

• VMware Aria Suite

Issue/Introduction

When issuing the following command on Primary and Replica nodes, vPostgres returns a max connection result.

• su - postgres -c "/opt/vmware/vpostgres/current/bin/psql -p 5433 -A -t -c \"SHOW max_connections;\""

However, when the same command is issued on the Data node, the following error displayed:

psql.bin: error: connection to server on socket "/tmp/.s.PGSQL.5433" failed: No such file or directory

Environment

Aria Operations 8.10

Aria Operations 8.12

Aria Operations 8.14

Aria Operations 8.16

Aria Operations 8.17

Cause

Port 5433 establishes the connectivity from the data node within the same cluster to the Postgres Central DB on the Primary node.  This port is only available on the Primary/Replica node.

Resolution

The following command can only be issued and will only get a result from the Primary/Replica node:

• su - postgres -c "/opt/vmware/vpostgres/current/bin/psql -p 5433 -A -t -c \"SHOW max_connections;\""

Additional Information

VMware Ports and Protocols