Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
How do i connect postgresql db from visual studio 2019 ? Question Question
Setting up user with pg_monitor role Question Question

Question

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

Posted October 6, 2021 96 views
PostgreSQLDigitalOcean Managed PostgreSQL Database

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/

Add a comment
Rajkishore
By:
Rajkishore

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
How do i connect postgresql db from visual studio 2019 ? Question Question
Setting up user with pg_monitor role Question Question

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.

×
Submit an Answer
1 answer
Rajkishore October 6, 2021

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

Reply Report

Related

Looking for something else?

Ask a new question Search for more help