Creating a PostgreSQL database

New in 20.0.3 Create a PostgreSQL database before installing Application Engine.

About this task

Restriction: You cannot use the same database and database user for Application Engine and any other component, such as Business Automation Studio or IBM Business Automation Workflow. You can use a shared database but you must use a different database user for each component.

Procedure

To create the Application Engine database, run the following command on your local or remote database server:
```
-- create a new user
create user APP_ENGINE_DB_USER_NAME with password 'APP_ENGINE_DB_PASSWORD';

-- create database APP_ENGINE_DB_NAME
create database APP_ENGINE_DB_NAME owner APP_ENGINE_DB_USER_NAME;

-- The following grant is used for databases
grant all privileges on database APP_ENGINE_DB_NAME to APP_ENGINE_DB_USER_NAME;
```
where:
- APP_ENGINE_DB_USERNAME is the username that the Application Engine uses to connect to the database.
- APP_ENGINE_DB_PASSWORD is the password that the Application Engine uses to connect to the database.
- APP_ENGINE_DB_NAME is the database name for the Application Engine database, it is case sensitive.
New in 20.0.3 If IBM Business Automation Application data persistence is enabled, it needs one object store from IBM FileNet® Content Manager. You can either reuse the existing one and specify it for the object_store_name parameter or create one named something like AEOS, which stands for application engine object store.
- To create the databases for IBM FileNet Content Manager, create a database for the Content Platform Engine Global Configuration Database (GCD) and one database for the content stores. For more information, see Preparing the databases.
- To create one object store for Business Automation Application data persistence but not reuse the existing one, you must create one database, such as one named AEOSDB. For more information, see Setting up a PostgreSQL database for Content Platform Engine.