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
file_fdw
and adminpack
PostgreSQL extensions. If these two extensions are not available by default, install them manually.Procedure
-
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 |
-
Save and close the file.
-
Run the
db-setup.sh
script.