Manual Installation of PostgreSQL Database

This section lists the steps to install TIBCO Product and Service Inventory with PostgreSQL database setup in manual mode.

For information about how to install TIBCO Product and Service Inventory follow the steps 1 through 15 in Installing in GUI Mode, where installation type is selected as Typical and then perform the following steps:

    Procedure
  1. Ensure that you have the compatible version of PostgreSQL database installed and running successfully on your computer.
  2. After installation of TIBCO PSI, under $PSI_HOME/scripts/postgreSQL/, run install.sh for linux. Note that this utility takes the arguments of PGHOME, PGHOST, PGPORT, PGDATABASE, PGSuperUSER, PGSuperuserPASSWORD, PSIDBUSER, PSIDBPASSWORD, PSIDBSCHEMA, and PSIDBDATATBSSTORAGE.

Example 1

./install.sh <PG_HOME> <PG_HOSTNAME> <PG_PORTNo> <PG_DATABASENAME> <PG_SUPERUSERNAME> <PG_SUPERUSERPASSWORD> <PSI_NEW_DB_USER> <PSI_NEW_DB_PASSWORD> <PSI_NEW_PG_DB_SCHEMA> <PSI_PG_TABLESPACE>

Example 2

./install.sh /apps/PostgreSQL/9.6 localhost 5432 postgresdb postgres postgres psi101pguser psi101pgpassword psi101pgdbschema psi101pgtablespace

This creates new db schema, new db user, new db password, new tablespace, and all the Data Definition Language (DDL) required for Database.

Note: You can check the logs in the log directory, <PSI_HOME>/scripts/postgreSQL/logs/DbSetup_outputs.log. This directory is created with log statements. If there is any issue in the log file then fix the issue and run the install.sh utility again.