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 trustFor more information about the pg_hba.conf file, see PostgreSQL documentation.