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
- Ensure that you have the compatible version of PostgreSQL database installed and running successfully on your computer.
- 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.
<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.