Creating a PostgreSQL Database for the TIBCO PSI User

Create a PostgreSQL database for the TIBCO PSI user and default Tenant by configuring and running the following script:
$PSI_HOME/database-scripts/psi/postgreSQL/bin/db-setup.sh

Before you beginIn bulkload API, create internal tables on the psi server by using the file_fdw and adminpack PostgreSQL extensions. If these two extensions are not available by default, install them manually.

Procedure

  1. Open the $PSI_HOME/database-scripts/psi/postgreSQL/bin/postgres_psi_db.properties file in a suitable editor and update the following values in the script:

Property

Value

PG_HOME C:/Program Files/PostgreSQL/11/bin

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_PSI_USER

New TIBCO PSI user

PG_PSI_PASSWORD

Password for the TIBCO PSI user

PG_PSI_DATABASE

TIBCO PSI database name

PG_PSI_SCHEMA

TIBCO PSI schema

PG_PSI_TABLESPACE_LOCATION

PSI tablespace location

PG_PSI_TABLESPACE

TIBCO PSI tablespace

IS_CLOUD_PLATFORM false
EXECUTE_DDL_DML_ONLY false
BASE_INSTALLATION_SCRIPTS fos_psi_ddl.sql
  1. Save and close the file.

  2. Run the db-setup.sh script.