How do login into vIDM database

Arun Nukula
Arun Nukula
1 min read

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

Never miss a post

New guides on VMware Cloud Foundation, Aria Suite, and infrastructure automation. Follow along in your feed reader and new posts show up as soon as they are published.

Subscribe via RSS