Creating Seed Data Manually for PostgreSQL Database

You can create seed data through manual configuration.

Procedure

  1. Navigate to $MQ_HOME\db\postgreSQL\install and run the install.bat or install.sh script.
  2. On the command line, enter the following details:
    • PostgreSQL home directory
    • IP address or host name and port of the PostgreSQL database. The default port for PostgreSQL is 5432. Ensure that it is not in use.
    • Database name that you want to create
    • Administrator credentials are required to create a database on PostgreSQL
    • The new user name that you can use in TIBCO MDM, the password of new user, and schema
    • Storage location for the data table space, index, data fragments table space, temporary data table space, temporary index table space for TIBCO MDM database
    • The name and description for TIBCO MDM instance
    The script creates the sequences, tables, indexes, triggers, and views in the appropriate table spaces and inserts seed data into the tables.
  3. Verify the log file created in the %MQ_HOME%\db\postgreSQL\install\logs folder.
    The seed data for PostgreSQL database is created, you can use this as ...............