TIBCO ActiveMatrix Administrator Server Database Requirements

The following section is an update to the topic Create TIBCO ActiveMatrix Administrator Server of 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. Before configuring TIBCO ActiveMatrix Administrator Server using TIBCO Configuration Tool (TCT), you must set up the PostgreSQL database as mentioned in the following table:

Database Configuration Notes
PostgreSQL
  1. Create the database user using pgAdmin or SQL Shell and grant required privilege.
  2. Create the database. The user created in the step 1 must be the owner of the database.
  3. In pgAdmin or SQL shell, run the following queries for the database created in the step 2 :
    CREATE FUNCTION pg_catalog.text(bigint) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int8out($1));';
    CREATE CAST (bigint AS text) WITH FUNCTION pg_catalog.text(bigint) AS IMPLICIT;
    
    CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int4out($1));';
    CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer) AS IMPLICIT;
    
    CREATE FUNCTION pg_catalog.text(smallint) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int2out($1));';
    CREATE CAST (smallint AS text) WITH FUNCTION pg_catalog.text(smallint) AS IMPLICIT;