Skip to content

Instantly share code, notes, and snippets.

@boina-n

boina-n/Hawq-cups

Last active Jan 27, 2017
Embed
What would you like to do?
How to create a user provided service with an external Hawq DB
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:gpadmin@10.0.2.15:5432/template1"}'
cf update-user-provided-service ccdb-pg -p '{"uri":"postgres://gpadmin:gpadmin@10.0.2.15:5432/template1"}'
postgres://gpadmin:gpadmin@10.0.2.15:5432/template1
"credentials":{
"uri":"postgres://__username__:__password__@__hostname__:__port__/__database__"
}
cf restage cf-ex-phppgadm
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.