arunnukula

Experienced Technology Product Manager adept at steering success throughout the entire product lifecycle, from conceptualization to market delivery. Proficient in market analysis, strategic planning, and effective team leadership, utilizing data-driven approaches for ongoing enhancements.

How do login into vIDM database

Arun Nukula

Aug 17, 20201 min read

Updated: Jun 29, 2021

As a first step fetch the password using below command

cat /usr/local/horizon/conf/db.pwd

Example:-

labidm:~ # cat /usr/local/horizon/conf/db.pwd
D4RSIrlpRNU5btYHYGOAySkFyykamPHa

Then execute

 psql -U horizon saas

This will prompt you to enter the password, copy the password extracted using the first command and then paste it and hit enter.

You would be logged into vIDM database

labidm:~ # psql -U horizon saas
Password for user horizon:
psql.bin (9.6.16 (VMware Postgres 9.6.16.0-15591078 release))
Type "help" for help.

saas=>

Enter \dt at the saas=> prompt to list all the tables