Unable to create Clarity DB LINK in new PostgreSQL "could not open extension control file"

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We have installed a new PostgreSQL server and restored the Clarity and DWH databases.

When we run the DWH db link command or the app link command, we get the error:

 

create extension postgres_fdw;

ERROR: could not open extension control file "/usr/share/pgsql/extension/postgres_fdw.control": No such file or directory SQL state: 58P01

Environment

Release : Any

Resolution

This is an issue with postgis in PostgreSQL, it has to be correctly installed and configured