Category Archives: PostgreSQL

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               md5 host    all             all            md5 host    all             all            md5 Insert the Ip addresses that are authorized to connect to postgreSQL into the pg_hba.conf file.