CB Response: Psql Command Fails With Role "Postgres" Does Not Exist

Products

• Carbon Black EDR (formerly Cb Response)

Issue/Introduction

Running the command: /usr/pgsql-10/bin/psql -p 5002
Fails with error: psql: FATAL: role "postgres" does not exist

Environment

• CB Response: 6.x and Higher 
• CentOS/RHEL: All Supported Versions

Cause

This is caused by port 5002 not being open on the master server

Resolution

Make sure that port 5002 is open and accessible on the master server