Restrict the connection permission to vFabric Postgres

Restrict the permission to connect to vFabric PostgreSQL by entering the follow line into /var/vmware/vpostgres/9.2/pgdata/pg_hba.conf: # “local” is for Unix domain socket connections only local   all             all                                     trust # IPv4 local connections: host    all             all             127.0.0.1/32            md5 host    all             all             10.51.29.201/32         md5 host    all             all             10.51.29.202/32         md5 Insert the Ip addresses that are authorized to connect to postgreSQL into the pg_hba.conf file.

How to change vFabric PostgreSQL DB User Password

If you need to change the password on for existent user (in my case vcac user), just follow the steps below. Login into vFabric Postgres as root and then: # su postgres  # /opt/vmware/vpostgres/9.2/bin/psql when you’re in: ALTER USER vcac WITH PASSWORD ‘<newpassword>’; \q To check if the new credentials are valid: Login into vFabric Postgres as root… Read More »