Installing pg_ivm for AWS RDS

[Hemsza]

How to add pg_ivm as cutsom extension using pg_tle.

[yss14]

@Hemsza If you find a way, I would also be interested.

[gsharp021]

I need this as well, please and thank you!

[mansueli]

I see some code in C, which isn't a trusted language. Is it possible to have it in Rust? (so we can have it on pg_lte)

Or is it possible to install it just with the SQL scripts?

[elsebastiann]

Any news on this guys?

[yugo-n]

Unfortunately, as @mansueli says, extensions that pg_tle can make are limited to trusted languages, and pg_ivm's functions are written in C, so we cannot install pg_ivm by using pg_tle.

If we rewritten pg_ivm in a trusted language, it might work, but it does not seem realistic to me because pg_ivm calls C functions in the PostgreSQL core code internally.

[rotten]

Contact your AWS TAM (Technical Account Manager) and have them add your vote for this extension being officially supported. Presumably, if they get enough votes, they'll actually commit some people to adding support for it some day.

[yoni-yad2]

Also please upvote here:
https://repost.aws/questions/QUOtJI7pRBSRSJw7FpszR2WQ/will-pg-ivm-extension-be-supported-in-aws-rds-postgresql-when

And here:
https://repost.aws/questions/QUF12RpagpTey5vszbg4Fm9w/pg-ivm-plugin-for-aurora-postgresql