Question

Not able to Install "plperlu" as Extension for Postgres managed database

Posted on October 6, 2021
DigitalOcean Managed PostgreSQL Database PostgreSQL
Asked by Rajkishore J

Hi,

When I am trying to create the Postgres extension “plperlu”, I am getting the below error.

defaultdb=> CREATE EXTENSION plperlu;
ERROR:  permission denied to create extension "plperlu"
HINT:  Must be superuser to create this extension.

This extension is listed under the supported extension section.

https://docs.digitalocean.com/products/databases/postgresql/resources/supported-extensions/

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Rajkishore J

DigitalOcean Employee

• October 6, 2021

Accepted Answer

Hi there,

Unfortunately, DigitalOcean does not support the “plperlu” Postgres extension as it’s an untrusted language that would allow the full ability to access anything the Postgres process can.

This extension will be removed from the DO soon from the supported list of Postgres extensions.

Regards, Rajkishore