19 December,19 at 03:54 PM
Problem:
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
Cause:
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.
Workaround:
The extension file will need to be installed manually on RHEL 7.x, using the below command.
yum install postgresql12-contrib