Question
Enable custom extension for PostgreSQL
- Posted on November 19, 2022
- DigitalOcean Managed PostgreSQL DatabasePostgreSQL
Asked by Arthur
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.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
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.
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:
Hope that helps! - KFSys.