Resolving the "422 UNPROCESSABLE ENTITY The specified extension <'ext_name'> is not present in shared_preload_libraries" error
Written by
Updated at November 27, 2023
Issue description
When trying to install a database extension following the guide, you see this error:
422 UNPROCESSABLE ENTITY The specified extension 'EXT_NAME'
is not present in shared_preload_libraries.
Solution
This error states that the EXT_NAME flag is not set in the cluster.
Please set it as follows: Cluster overview -> Edit cluster -> DBMS settings -> Shared preload libraries, then choose EXT_NAME. After that, you can install the extension.
Alert
When you make changes to cluster settings, the PostgreSQL server reboots.
We provide more details on managing extensions in our documentation.