Creating Database Using PostgreSQL

Before you begin

The PostgreSQL server must be running.

    Procedure
  1. Using a suitable SQL client application, connect to the PostgreSQL server.
  2. Create a new database with a suitable name. For example:
    $ createdb bpmdb
  3. Run the script as the database administrator to create the bpmuser role (user). TIBCO BPM Enterprise uses this role whenever it connects to the BPM database.
    CONFIG_HOME/tibco/cfgmgmt/bpm/database/postgres/createuser.sql
    Note: The BPME database tables are generated automatically using the BPME utility.