Remote edit of PostgreSQL Database?

[cloerner]

Hi @all,

is it possible to edit the included PostgreSQL Database with an a tool from a remote machine?

Thank you.

[igorstoyanov]

Yes. You need to turn on ssh from VCAC VA Management UI. Login via ssh to the VCAC VA and execute the following scripts: sed -i -re 's/^#(listen_addresses=.\*.)/\1/' /var/vmware/vpostgres/current/pgdata/postgresql.conf /etc/init.d/vpostgres restart Note, this will open the db port and it is potential security issue. So, it is not advisable to be done.

[bweck]

Hey Igor,

What's the password to be able to access vcac's local postgres db? I'm trying to use one of my vcac appliances as the postgres DB for a vcac appliance cluster.

[igorstoyanov]

You can see the password (it might be generated per installation or use default) if you ssh to VCAC VA  and open to /etc/vcac/server.xml . Look for resource named: <Resource name="jdbc/cafe" ....