Configuring TIBCO Product and Service Catalog for PostgreSQL

This topic explains the configuration of TIBCO Product and Service Catalog for use with PostgreSQL 9.6.x version and later.

If you install TIBCO MDM using a standalone installer and if you install PostgreSQL 9.6.x on your system, you must configure TIBCO Product and Service Catalog for PostgreSQL.

Prerequisites

Before configuring the TIBCO Product and Service Catalog for PostgreSQL 9.6.x version, the following prerequisites have to be met:
  • Install TIBCO MDM 9.1.2 , which supports JBOSS, and verify the installation logs to confirm a successful installation. For more details related to TIBCO MDM 9.1.2 installation, see TIBCO® MDM Installation and Configuration Guide and the TIBCO MDM 9.1.2 Readme file.
  • Configure JBOSS EAP 7.0. For more details related to configuring JBOSS EAP 7.0, see the topic "TIBCO MDM Installation on Application Servers" within the TIBCO® MDM Installation and Configuration Guide.
  • Install TIBCO Enterprise Message Service 8.4 and create the channels for TIBCO MDM. For more details, see TIBCO® MDM Installation and Configuration Guide.
  • Install PostgreSQL 9.6.x, verify the installation, and ensure that the folder structure conforms to the requirements of TIBCO MDM 9.1.2 database script creation.

Procedure

  1. Run the install.sh file within the $MQ_HOME/db/postgreSQL/install/ location. Enter the necessary details, verify whether the tables and seed data are proper or not.
  2. Edit the ConfigValues.xml file, within the $MQ_HOME/config/ location, and also edit the standalone.xml file within the $JBOSS_HOME/standalone/configuration/ location and specify the database details. In the ConfigValues.xml file search for the group DatabaseServerType and enter the value POSTGRES. You can specify the database details using the Configurator as well.
  3. Start the following servers: EMS, PostgreSQL, and JBOSS EAP.
  4. Login to the TIBCO MDM enterprise using the super admin enterprise name Tibcocim.
    Note: This step is performed only to verify if TIBCO MDM installation was successful.
  5. Stop the JBOSS server.
  6. Install TIBCO Product and Service Catalog and check the logs to see if the post installation activities were successful.
  7. Ensure that PostgreSQL server is up and running.
  8. Create the TIBCO Product and Service Catalog seed data in the TIBCO MDM database.
    1. Browse to the $AC_HOME/db/postgreSQL/install.
    2. Run install_ac.sh.
    Note: The install_ac.sh file creates seed data only for the TIBCO Product and Service Catalog and not for the TIBCO MDM database.
  9. Start/Restart the following servers on: EMS, PostgreSQL, and JBOSS EAP. For more details on TIBCO Product and Service Catalog Enterprise, see Creating TIBCO Product and Service Catalog Enterprise with Metadata Manually.