News for hackers. Stuff that matters.

A comment on dbdev - The Database Package Manager for PostgreSQL Trusted Language Extensions. Parent comment

Re:dbdev - The Database Package Manager for PostgreSQL Trust... by paulddraper on Friday April 14, 2023 @12:52PM (#35571698)
No.

RDS has a strict list of approved extensions. (Since AWS is on the hook for the system stability, security, replication, etc.)

[ Parent | on HN ]
Re:dbdev - The Database Package Manager for PostgreSQL Trust... by supamichelp on Friday April 14, 2023 @12:57PM (#35571771)
RDS 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/Postg...

[ Parent | on HN ]
Re:dbdev - The Database Package Manager for PostgreSQL Trust... by samwillis on Friday April 14, 2023 @12:59PM (#35571793)
Partially 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://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Postg...

[ Parent | on HN ]
Re:dbdev - The Database Package Manager for PostgreSQL Trust... by paulddraper on Friday April 14, 2023 @01:29PM (#35572174)
Oh cool!
[ Parent | on HN ]