You can connect to a vFabric Postgres database in several different ways, including the pgAdmin tool.

The Windows pgAdmin tool works only with Windows 32-bit systems. If you run Windows 64-bit, install the 32-bit versions of the vFabric Postgres client tools. The tool's installer places the 32-bit tools in the C:\Program Files (x86) tree.

If you do not have pgAdmin installed, download the version of the tool that is appropriate for your system from the Postgres Web site and install the tool.

Obtain the vFabric Postgres connection string. See Obtain the Connection String.

Obtain the Data Director DB Name Service IP address. See Obtain the DB Name Service IP Address.

On Windows, ensure that pgAdmin uses the vFabric Postgres

libpq library.

a

Copy the C:\Program Files\pgAdmin III\version directory to C:\Program Files\pgAdmin III\version-vPostgres, where version is the pgAdmin version number, for example, 1.14.

b

Copy all the files in your C:\Program Files\VMware\vPostgres\1.0\bin directory to C:\Program Files\pgAdmin III\<version>-vPostgres.

1

Start pgAdmin from the C:\Program Files\pgAdmin III\version-vPostgres directory.

2

Select File > Add Server.

3

Specify the connection information when prompted.

Option

Description

Name

A meaningful name for the server, such as Data Director.

Host

The {UUID}.[DB Name Service IP or FQDN] part of the connection string.

Port, Service, Maintenance DB

Leave the defaults.

Username

Database user name. This is usually the database owner user ID.

Password

Password for the database user. You can optionally store the password. pgAdmin stores the password as plain text.

Color (Optional)

Color to denote this server in the object browser and in diagrams.

Server group (Optional)

Enter a server group in which to place this server, or accept the default.

4

Click the Advanced tab and type the DB Name Service IP address in the Host field.

5

Click OK.