3 ms·
No. RDS has a strict list of approved extensions. (Since AWS is on the hook for the system stability, security, replication, etc.)
by paulddraper 4y ago
No.
RDS has a strict list of approved extensions. (Since AWS is on the hook for the system stability, security, replication, etc.)
- supamichelp 4y agoRDS for Postgres 14+ does come with pg_tle, but it does not come with pgsql-http, so you cannot use the dbdev installer. But, you can still install TLEs, you just have to do so "by hand" by calling `pgtle.install_extension()` yourself, probably from a migration script depending on your tooling. See the RDS docs here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_trusted_language_extension.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Postg...
- samwillis 4y agoPartially correct, this doesn't work with RDS as you can't install pgsql-http (a requirement for automatic install). However all the extensions listed are "Trusted Language Extensions for PostgreSQL" which was developed by AWS to enable installing extensions written in "Safe" languages. So I believe that all the extensions listed could be installed manually. https://github.com/aws/pg_tle https://github.com/aws/pg_tle https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_trusted_language_extension.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Postg...
- paulddraper 4y agoOh cool!