How to create a user provided service with an external Hawq DB

Hawq-cups

vboxmanage list vms

vboxmanage import /opt/application/PCF-BDS/HDB-Sandbox-2.01-vbox.ova

VBoxManage modifyvm "HDB-Sandbox-2.01-vbox" --natpf1 delete http 

VBoxManage modifyvm "HDB-Sandbox-2.01-vbox" --natpf1 "http,tcp,,8888,,80"

VBoxManage modifyvm "HDB-Sandbox-2.01-vbox" --natpf1 delete gpdb 

VBoxManage modifyvm "HDB-Sandbox-2.01-vbox" --natpf1 "gpdb,tcp,,5432,,10432"

vboxmanage startvm "HDB-Sandbox-2.01-vbox" --type headless

vboxmanage controlvm "HDB-Sandbox-2.01-vbox" poweroff

vboxmanage showvminfo "HDB-Sandbox-2.01-vbox" | less



Mbps, Boot priority: 0, Promisc Policy: deny, Bandwidth group: none
NIC 1 Settings:  MTU: 0, Socket (send: 64, receive: 64), TCP Window (send:64, receive: 64)
NIC 1 Rule(0):   name = gpdb, protocol = tcp, host ip = , host port = 5432, guest ip = , guest port = 5432
NIC 1 Rule(1):   name = http, protocol = tcp, host ip = , host port = 80, guest ip = , guest port = 80
NIC 1 Rule(2):   name = ssh, protocol = tcp, host ip = , host port = 2200, guest ip = , guest port = 22
NIC 1 Rule(3):   name = zep, protocol = tcp, host ip = , host port = 9995, guest ip = , guest port = 9995
NIC 1 Rule(4):   name = zepp, protocol = tcp, host ip = , host port = 8080, guest ip = , guest port = 8080
NIC 2:           disabled

vboxmanage unregistervm --delete HDB-Sandbox-2.01-vbox


psql -h 10.0.2.15 -p 5432 -U postgres

gpadmin    5868      1  0 06:01 ?        00:00:00 /usr/local/hawq_2_0_1_0/bin/postgres -D /data/hawq/segment -i -M segment -p 40000--silent-mode=true
gpadmin    5717      1  0 06:01 ?        00:00:00 /usr/local/hawq_2_0_1_0/bin/postgres -D /data/hawq/master -i -M master -p 10432 --silent-mode=true


psql -h localhost -p 5432 -U gpadmin template1

cf cups ccdb-pg -p '{"uri":"postgres://gpadmin:[email protected]:5432/template1"}'

cf update-user-provided-service ccdb-pg -p '{"uri":"postgres://gpadmin:[email protected]:5432/template1"}'

postgres://gpadmin:[email protected]:5432/template1 

"credentials":{
    "uri":"postgres://__username__:__password__@__hostname__:__port__/__database__"
}

cf restage cf-ex-phppgadm