Using a PostgreSQL Database

When installing a PostgreSQL database, MFT requires support for the CITEXT data type.

To enable the CITEXT data type, follow this procedure:

Procedure

  1. Install the PostgreSQL citext extension.
  2. Execute this SQL command as a superadmin for the Posgresql MFT database:
    CREATE EXTENSION IF NOT EXISTS CITEXT;

Result

When PostgreSQL is selected as the database, MFT verifies that the citext extension is installed for the MFT database. If it is not installed for the MFT database, the installation terminates.