Creating base database on a PostgreSQL server

Create a base database on your remote PostgreSQL database for your Document Processing Extension environment. If you plan to use a user-provided remote PostgresSQL server with Manual DB management option for your Document Processing Extension environment, you must create the base database on your remote PostgreSQL server before installing the Document Processing Extension stack.

Before you begin

Download and extract the dpedeploy tool and copy the database scripts to your database server. For more information, see Downloading and extracting the dpedeploy tool.

About this task

The provided DB scripts in ibm_assets/databases/PG folder from the dpedeploy tool can be used to both create and initialize the base database for Document Processing Extension. If you prefer to create your own database and use the scripts only to initialize the database, then the databases that you create must meet the following minimum requirements:

  • Set the PostgreSQL server code to UTF-8 encoding.
  • Grant admin privileges to the database user allowed to access the database.

Procedure

  1. To create and initialize the base database by using the provided script.
    1. Go to the PG folder.
    2. Run the CreateBaseDB.sh script.
      Note: The user must have privileges to run the psql command line and admin privileges on PostgreSQL.
  2. Manually initialize the base database if you created your own base database instead of running the CreateBaseDB.sh script.
    Note: You can skip this step if you have already created and initialized the base database by using the CreateBaseDB.sh script.
    1. Go to the PG folder.
    2. Run the InitBaseDB.sh script to initialized the base database.
      Note: The user must have privileges to run the psql command line and admin privileges on the base database.
    3. When prompted, enter the following information:
      1. Name of the base database that you created.
      2. Name of an existing database user with read and write privileges for the base database.

What to do next

Go to and complete the steps in Installing Document Processing Extension.