Configuring PostgreSQL

Review and complete the instructions to configure PostgreSQL on UNIX or Linux®.

For more information about PostgreSQL instructions, see the PostgreSQL documentation.

Procedure

Configure the PostgreSQL database.
1. Download and install the PostgreSQL database.
2. Set up schema, and ensure that the PostgreSQL database is created and contains the appropriate data.
3. Set up the PostgreSQL user privileges.
4. Configure the PostgreSQL parameters.
5. Verify that you can establish a connection to the PostgreSQL database from an external system or a third-party JDBC client.
Enable Sterling™ Order Management System Software to connect to the PostgreSQL database.
1. Download the PostgreSQL database JDBC driver.
2. Install the PostgreSQL database JDBC driver into your Sterling Order Management System Software installation.
  - If you are using Operator, Install the PostgreSQL database driver through Operator annotations. Then, configure the database connection parameters and data management properties through operator.
  - If you are using the DTK, install developer toolkit with PostgreSQL database.
  - If you are using the om-base image customizations, see Customizing and generating container images.
3. Extend your database, if necessary.
Create the database tables.
- If you are using the DTK or Operator in the upgrade or install mode, the table alters are automatically applied.
- If you want to manually create the database tables, follow the steps explained in manually create the database tables.