Creating a PostgreSQL Database for Jeopardy Service User

    Procedure
  1. Open the $OM_HOME/db/dbscripts/postgreSQL/jeopardy/bin/postgres_jeopardy_db.properties file in a suitable editor and update the following values:
    Property Update the Value for
    PG_HOME PostgreSQL database home
    PG_HOST PostgreSQL database host
    PG_PORT PostgreSQL port
    PG_SUPER_USER_NAME PostgreSQL superuser name
    PG_SUPER_USER_PASSWORD PostgreSQL superuser password
    PG_SUPER_USER_DATABASE PostgreSQL superuser database
    PG_JEOPARDY_USER New Jeopardy user
    PG_JEOPARDY_PASSWORD Password for the Jeopardy user
    PG_JEOPARDY_DATABASE Jeopardy database name
    PG_JEOPARDY_SCHEMA Jeopardy schema
    PG_JEOPARDY_TABLESPACE Jeopardy tablespace
    PG_JEOPARDY_TABLESPACE_LOCATION Jeopardy tablespace location
    IS_CLOUD_PLATFORM The default value is false. Set it to true if creating a database on a cloud platform.
    DEFAULT_TENANT TIBCO
    EXECUTE_DDL_DML_ONLY The default value is false. Set it to true if you run only DDL/DML.
    BASE_INSTALLATION_SCRIPTS jeopardy_database_ddl.sql,jeopardy_lock.sql,jeopardy_database_dml.sql
  2. Save and close the file.
  3. Run the $OM_HOME/db/dbscripts/postgreSQL/jeopardy/bin/db-setup.sh script.