Manual Installation of PostgreSQL Database

This section lists the steps to install TIBCO Fulfillment Subscriber Inventory with PostgreSQL database setup in manual mode.

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

Procedure

  1. Ensure that you have the compatible version of PostgreSQL database installed and running successfully on your computer.
  2. After installation of FSI, under $FSI_HOME/scripts/postgreSQL/, run install.sh for linux. Note that this utility takes the arguments of PGHOME, PGHOST, PGPORT, PGDATABASE, PGSuperUSER, PGSuperuserPASSWORD, FSIDBUSER, FSIDBPASSWORD, FSIDBSCHEMA, and FSIDBDATATBSSTORAGE.

Example 1

./install.sh <PG_HOME> <PG_HOSTNAME> <PG_PORTNo> <PG_DATABASENAME> <PG_SUPERUSERNAME> <PG_SUPERUSERPASSWORD> <FSI_NEW_DB_USER> <FSI_NEW_DB_PASSWORD> <FSI_NEW_PG_DB_SCHEMA> <FSI_PG_TABLESPACE>

Example 2

./install.sh /apps/PostgreSQL/9.6 localhost 5432 postgresdb postgres postgres fsi101pguser fsi101pgpassword fsi101pgdbschema fsi101pgtablespace

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, <FSI_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.