You can connect to a vFabric Postgres for Data Director database by using custom connection strings. If you are using the standalone version of vFabric Postgres, you do not need to customize your connection strings.

Deploy the vFabric Postgres Standard Edition for Data Director virtual appliance in your environment.

Use the following connection string.

jdbc:postgresql://{UUID}.host_name/rdb_name?user=<user name>

The curly brackets, {}, are part of the connection string and enclose the UUID.

Assume that you use JDBC to connect to a database with the following characteristics.

Database name

myDB

Host name

w1-devtest-22.dev.mycorp.com

UUID

d35f7ab1-d70e-4d98-c121-122f68e4ab60

User name

dbowner

You can use the following JDBC connection string.

jdbc:postgresql://{d35f7ab1-d70e-4d98-c121-122f68e4ab60}.w1-devtest-22.dev.mycorp.com/mydb?user=dbowner