Configuring TIBCO Product and Service Catalog for PostgreSQL

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

If you install TIBCO MDM using a standalone installer and if you install PostgreSQL 13.4 on your system, you must configure TIBCO Product and Service Catalog for PostgreSQL.
Before you beginBefore configuring the TIBCO Product and Service Catalog for PostgreSQL 13.4 version, the following prerequisites have to be met:
  • Install TIBCO MDM 9.3.1.HF1, which supports JBOSS EAP or Wildfly, and verify the installation logs to confirm a successful installation. For more details about TIBCO MDM 9.3.1 installation, see TIBCO® MDM Installation and Configuration Guide and the TIBCO MDM 9.3.1 Readme file.
  • Configure JBOSS EAP/Wildfly. For more details related to configuring JBOSS EAP/Wildfly, see the topic "TIBCO MDM Installation on Application Servers" within the TIBCO® MDM Installation and Configuration Guide.
  • Install TIBCO Enterprise Message Service 8.6 and create the channels for TIBCO MDM. For more details, see TIBCO® MDM Installation and Configuration Guide.
  • Install PostgreSQL 13.4, verify the installation, and ensure that the folder structure conforms to the requirements of TIBCO MDM 9.3.1 database script creation.
    Procedure
  1. Run the install.sh file within the $MQ_HOME/db/postgreSQL/install/ location. Enter the necessary details, and 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/Wildfly.
  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 the 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/Wildfly. For more details on TIBCO Product and Service Catalog Enterprise, see Creating TIBCO Product and Service Catalog Enterprise with Metadata Manually .