Search code examples
postgresqlamazon-rdsgoogle-cloud-sql

Is it possible to use an external library to extend functionality of cloud sql postgres?


There are external libraries that can be installed used with postgres, I'm wondering if something similar can be done with AWS RDS postgres or Google Cloud SQL postgres.

For example the Bingo library adds cheminformatics functionality to postgres: http://lifescience.opensource.epam.com/bingo/bingo-postgres.html Could Bingo be added to a AWS RDS or Cloud SQL postgres instance?

If either of these are possible, could you point me towards documentation or search terms I can use to learn more.


Solution

  • I got a definitive answer from AWS support that one cannot do this on RDS postgres. They have a list of libraries they already support here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions.96x

    And an email address you can write to requesting additional ones: [email protected] (I requested they add Bingo).

    Here is the equivalent page listing extensions supported by Google Cloud SQL: https://cloud.google.com/sql/docs/postgres/extensions

    Equivalently, they recommended the GCP issue tracker forum, tagged with Cloud SQL etc. to request support for the extension, which I did here for example: https://issuetracker.google.com/issues/117212334