The base release of TrueSight Capacity Optimization (TSCO) version 20.02 does not support using Postgres version 12  as a backing database and, although the installer will run to completion, the database schema will be invalid and generate an error "[POST-INSTALL] Status PS_NOT_INSTALLED -- Primary Scheduler is not installed" (See KA 000378127).

The Database Requirements documentation still lists the highest PostgreSQL Database version supported as 11.x due to the official installation image available on the EPD site not supporting deployment against higher PostgreSQL versions.  If the TSCO 20.02 installation image has been patched before initial deployment of the product against a PostgreSQL version 12 or 13 database using the patch package associated with this KA then Postgres series version 12 is officially supported and any problems encountered can be reported to Technical Support for analysis and a workaround or resolution recommendation as is standard for a supported configuration.

The attached TSCO_installer_2002_pg12patch.sh updates the TrueSight Capacity Optimization (TSCO) version 20.02 installer image to be compatible with a PostgreSQL version 12.x database backend.  Once the script has been executed the installation image can then be used to deploy TSCO 20.02 successfully against those database versions.

NOTE: The TSCO_installer_2002_pg12patch.sh must be executed before the initial deployment of TSCO version 20.02 when backed by PostgreSQL version 12.x.  If the TSCO version 20.02 install had initially been run and deployed an invalid schema it will be necessary to fully clean up the TSCO installation and the database schema, patch the installation image, and then proceed with a fresh install of TSCO 20.02 using the patched installation image.

Patch installation instructions:

(1) Copy the TSCO 20.02 installation image to the desired machine.  This image can be copied anywhere but a good directory would be the desired installation image base directory (for example, the /opt/cpitinstall directory).  This is Step 1 of the Preparing to install the Application Server and ETL Engine documentation.  Do not proceed onto Step 2 in the documentation yet.

(2) Download the TSCO_installer_2002_pg12patch.sh into the desired installation image base directory, for example, /opt/cpitinstall.

(3) Ensure the TSCO_installer_2002_pg12patch.sh is executable:
  chmod 755 TSCO_installer_2002_pg12patch.sh

(4) Execute the patch:
  ./TSCO_installer_2002_pg12patch.sh [fully pathed installation image file name]

  For example:
  ./TSCO_installer_2002_pg12patch.sh /opt/cpitinstall/TSCO_AppServer_ver20.02.00_Linux.tar.gz

This will extract the TSCO 20.02 installation image into the directory where the TSCO_installer_2002_pg12patch.sh resides (which is why this script should reside in the desired installatio image base directory on the machine).

Example patch script output:

./TSCO_installer_2002_pg12patch.sh /opt/cpitinstall/TSCO_AppServer_ver20.02.00_Linux.tar.gz
Extracting installer file '/opt/cpitinstall/TSCO_AppServer_ver20.02.00_Linux.tar.gz' into directory /opt/cpitinstall
Patching /opt/cpitinstall/BCO/Disk1/files/bco/databaseschema/postgres/install/sequences_alignment.sql
Installer patched and ready to be executed at /opt/cpitinstall/BCO/Disk1

  (5) Once the installation image has been patched the installer can be executed using the normal installation workflow and it will be able to properly deploy the TSCO 20.02 database schema in a PostgreSQL version 12.x backed environment.