Creating a PostgreSQL Database for Jeopardy Service User
- Procedure
- 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 - Save and close the file.
- Run the
$OM_HOME/db/dbscripts/postgreSQL/jeopardy/bin/db-setup.sh
script.