Administrator Server Database Details

The following section is an update to the topic Administrator Server Database Details in the TIBCO ActiveMatrix Service Grid Installation and Configuration Guide.

Starting with TIBCO ActiveMatrix 3.4.0 Hotfix 002, PostgreSQL database versions 11.5 and 10.7 are supported. In PostgreSQL client authentication is controlled by pg_hba.conf file located in the database cluster's /data directory. By default PostgreSQL database listens TCP/IP connections only on the local loopback address localhost.

Therefore, before configuring PostgreSQL database using TIBCO Configuration Tool (TCT), you must add client machine IP address entry in the pg_hba.conf file. If the TIBCO ActiveMatrix Administrator is replicated, you must also add IP address of the machine on which ActiveMatrix Administrator is replicated in the pg_hba.conf file.

For example, if the client machine IP address is 172.20.143.0, then you must add entry in the pg_hba.conf file as:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
host    all             all             172.20.143.0/24         trust
For more information about the pg_hba.conf file, see PostgreSQL documentation.

Note: PostgreSQL database with SSL enabled is not supported in TIBCO ActiveMatrix 3.4.2.