Logging in to postgesDB

Products

• VMware Smart Assurance

Issue/Introduction

How do you log in to Postgres DB?

Environment

NCM - 10.1.x

Resolution

1. Log in to a Linux shell on the NCM host where the controldb is located (Application Server, Combination Server, or distributed Database Server) as 'root'.
2. Run the following command:

su - pgdba -c 'psql voyencedb voyence'
Provide password for user 'voyence' when prompted.