- Download Pivotal HD 3.0 VM from https://github.com/tzolov/vagrant-pivotalhd/.
- Install the VM with the default blueprint following instructions in the readme.
- Start the VM with
vagrant up. - Change the postgres config on
phd3.
vagrant ssh phd3
sudo vi /data/hawq/master/gpseg-1/pg_hba.confadd the following line
host all gpadmin 10.211.55.1/32 trust
- Use Ambari to restart the HAWQ service.
- To check that everthing is configured correctly, try to connect with
psql
psql -h10.211.55.103 -Ugpadmin