When configuring Centrify Report Services via the Configuration Wizard and the backend DB is PostgreSQL hosted on RHEL 7.x, the wizard errors out with the following error:
The Centrify Report Services Configuration Wizard cannot be completed due to an error that occurred:
ERROR [58P01] ERROR: could not open extension control file "/usr/pgssql-12/share/extension/uuid-ossp.control": No such file or directory; Error while executing query
When installing PostgreSQL on RHEL 7.x, for use with Centrify Reporting Services, the extension file 'uuid-ossp.control' is not installed automatically or by default. Whereas, this file is installed automatically on Windows installations of PostgreSQL.
The extension file will need to be installed manually on RHEL 7.x, using the below command.
yum install postgresql12-contrib
After the extension file has been installed, go back to the Windows machine where the Centrify Report Services is being installed and rerun the Centrify Report Services Configuration Wizard to finish the configuration.