Installing PostgreSQL/EMS

Use this procedure to install a PostgreSQL database and EMS.

Procedure

  1. Install the TIBCO Enterprise Messaging Server and start the server.
  2. Install the PostgreSQL Database.
    1. Download and install the PostgreSQL Database.
    2. Perform the server configuration by following the prompts in the PostgreSQL installer.
    3. Accept the default port value 5432, or enter your own port number.
    4. Download the following JDBC driver connector JAR files (postgresql-42.1.4.jar) to the TIBCO_HOME/afx/version/system/lib/db folder.
    Note: The TIBCO_HOME/afx/version/config/dbscripts/postgresql/folder contains two SQL scripts named postgresql_create and postgresql_drop. These scripts help you to administer the database in an efficient manner. The postgresql_create script indicates what you can expect in the database and the postgresql_drop script allows you to drop a table if you have a problem with the database. You should back up the data before using the postgresql_drop script.