Report this

What is the reason for this report?

Enable custom extension for PostgreSQL

Posted on November 19, 2022

My application functionality relays on custom postgres extension pg_similarity, while I was testing out GCP they were providing support for this extension and I enabled it just as usual with CREATE EXTENSION pg_similarity; but in DO managed db does not provide support for this extension. Is there a way I can install it manually? And if not, what would be the workaround for this?



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.
0

Accepted Answer

Hi @arthurmorel,

You can check the support extensions of the Managed Database PostgreSQL service here:

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

if the extension is not a part of this list, you can suggest it as an idea to be added here:

https://ideas.digitalocean.com/

Hope that helps! - KFSys.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.