Creating a PostgreSQL Database for the Broker Service User
- Procedure
- Open the
$OM_HOME/db/dbscripts/postgreSQL/broker/bin/postgres_broker_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_BROKER_USER
New Broker user PG_BROKER_PASSWORD
Password for the Broker user PG_BROKER_DATABASE
Broker database name PG_BROKER_SCHEMA
Broker schema PG_BROKER_TABLESPACE_LOCATION
Broker tablespace location PG_BROKER_TABLESPACE
Broker tablespace 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 running only DDL/DML. BASE_INSTALLATION_SCRIPTS
database_ddl.sql - Save and close the file.
- Run the
$OM_HOME/db/dbscripts/postgreSQL/broker/bin/db-setup.sh
script.