Configuring a PostgreSQL database for the IBM UrbanCode Deploy server

Before you install the server, install the PostgreSQL database, and provide the Java Database Connectivity (JDBC) JAR file for the server installation process.

Before you begin

Before you install the IBM® UrbanCode™ Deploy server, install PostgreSQL. If you are evaluating IBM UrbanCode Deploy, you can install the database on the same computer as the IBM UrbanCode Deploy server.

The command to install PostgreSQL on a Linux system might look like this example:

yum install postgresql-server

The command to start the PostgreSQL server might look like this example:

service postgresql initdb

When you install IBM UrbanCode Deploy, you need the PostgreSQL connection information, and a user account with table creation privileges.

Restriction: You cannot use the root user account.

Procedure

Create a database. The following commands are an example of how you might create this database:

CREATE DATABASE ibm_ucd;

CREATE USER ibm_ucd WITH PASSWORD 'password';

GRANT ALL PRIVILEGES ON DATABASE ibm_ucd TO ibm_ucd;

Log out of the PostgreSQL command line.
Obtain the PostgreSQL JDBC driver. The JDBC JAR file is included among the installation files. The driver is unique to the edition that you use.
When multiple drivers are available, you might need to consult with the database provider to determine which driver to use. The JDBC driver version to use might depend on the version of the database and the version of Java™ used by the IBM UrbanCode Deploy server.
Copy the JDBC JAR file to the installer_directory\lib\ext directory.
Begin server installation. See Installing the server. When you are prompted for the database type, enter postgres.
Provide the JDBC driver class that IBM UrbanCode Deploy uses to connect to the database. The default value is org.postgresql.Driver.
Next, provide the JDBC connection string. Typically, it uses this format:
```
jdbc:postgresql://DB_URL:DB_PORT/DB_NAME
```
This example shows a JDBC connection string:
```
jdbc:postgresql://localhost:5432/ibm_ucd
```
Enter the database user name and password that you created.

Feedback