How to get postgres dB password in sas visual investigator

Execute the below commands,

• Login to sas viya microservices server
• Execute — source /opt/sas/viya/consul.conf
• export CONSUL_HTTP_TOKEN= $(cat /opt/sas/viya/config/etc/SASSecurityCertificateFramework/tokens/consul/default/client.token)
• /opt/sas/viya/home/postgresql11/bin/psql -t -h 10.xxx.xxx.xxx -p 5432 -U dbmsowner postures

Substitute your microservices ip in above command, and mostly port will be 5432 if not,then give correct port on which postgres is running

☺