VMware Cloud Community
FSsysadmin
Enthusiast
Enthusiast

Editing the Postgres database on Vrealize Automation 7

Hi,

I'm trying to edit the PostgreSQL database in VRA 7 in order to erase the existing license key so i would be able to use the Eval License key

i'm using the solution specified in one of the posts here for this issue:

http://www.viktorious.nl/2015/04/16/how-to-change-vra-licensesunable-to-downgrade-existing-license-e...

the thing is i cannot login the database using psql

im using the following syntax:

/opt/vmware/vpostgres/current/bin/psql vcac vcac

and im getting a password promt, even though there shouldn't be any password

i've tried specifying a -w flag which enabled a passwordless login but it failed with an error

psql.bin: fe_sendauth: no password supplied

it looks like there is a password in the VRA 7 posgresql db, does someone know what it is? I've tried all the defaults

VMware1!, vmware, admin , password

Reply
0 Kudos
3 Replies
LenK
Enthusiast
Enthusiast

The following steps should do it:

     SSH into the vRA appliance as root.

     su - postgres

     cd /opt/vmware/vpostgres/current/bin

     ./psql

     \c vcac

At this point you should be connected to the vcac DB with the ability to execute SQL commands.

sascha_milic
Hot Shot
Hot Shot

Hi,

Just for a POC or Test environment (due to security reasons):

Add following line to /storage/db/pgdata/pg_hba.conf

host    vcac             vcac               0.0.0.0/0        trust


login as root, then

su - postgres

/opt/vmware/vpostgres/current/bin/pg_ctl reload -D /var/vmware/vpostgres/current/pgdata/

Now you are able to access the DB even from remote with an (windows) tool like pgAdmin

DB:vcac

User:vcac

PW:empty

Reply
0 Kudos
vTommyB
VMware Employee
VMware Employee

The vcac user account password is encrypted in v7.  See the following for instructions on how to decrypt it:  vRealize Automation vPostgres password | virtual devops.

Reply
0 Kudos