Creating a PostgreSQL database for IBM Content Navigator

Create a database and table space for the IBM Content Navigator database on PostgreSQL.

Before you begin

You can use your existing PostgreSQL server. If you don't have a PostgreSQL server, install a new PostgreSQL server to create a Navigator database.

  1. Install the PostgreSQL software.

    Many vendors and software as a service offering are available sources of a PostgreSQL instance. You can also download and install PostgreSQL at https://www.postgresql.org/download/.

  2. Log in as a superuser or check for the special CREATEDB privilege to create the database in the next step.

About this task

You create the table space and database for the IBM Content Navigator database.
Tip: PostgreSQL is case-sensitive and accepts identifiers only as lowercase.

If you want to use a special PostgreSQL user for your Navigator database, create the user ID before you create the database. You can also use an existing PostgreSQL user.

This variable definition list describes each value that you enter in the SQL commands.
  • The user is icn_user.
  • The database name is ICNDB.
  • The target data path of the navigator table space is /data/ICNDB.
  • The table space is ICNDB_ts.

Do the following steps to create the Navigator database.

Procedure

  1. Log in to the PostgreSQL server as the PostgreSQL administrator.
  2. Run the SQL command in the PSQL tool to create the table space for the database. 
    CREATE TABLESPACE ICNDB_ts OWNER icn_user LOCATION '/data/ICNDB';
  3. Create the database and configure it. 
    CREATE DATABASE ICNDB OWNER icn_user TEMPLATE template0 ENCODING UTF8 TABLESPACE ICNDB_ts;
REVOKE CONNECT ON DATABASE ICNDB FROM public;

What to do next

If you want to configure SSL for the Navigator database, see Configuring an SSL connection for PostgreSQL.