I want to download jsonbx to RDS instance. RDS PostgreSQL Features Supported shows only built-in features. Does this mean there is no way we can install an extension to RDS which is not in the Feature Matrix? Is there a work around for this?
Postgresql – Amazon RDS Postgresql adding new extensions
amazon-rdspostgresqlpostgresql-9.4
Related Question
- Postgresql – Amazon RDS non superuser create function in C
- Postgresql – How to create INOUT assignment cast on Amazon RDS PostgreSQL? If not possible, then why
- Amazon-rds – Amazon RDS t2.small as a production server
- Postgresql – unable to create schema on amazon rds for postgres
- Postgresql on Windows and custom extensions
- Amazon-rds – Support for libprotobuf-c on Amazon RDS
- Postgresql – How to install tds_fdw on AWS RDS for SQL Server
Best Answer
You can't add your own extensions to RDS, at least not ones that require superuser rights (like anything with C code). This is one of the downsides you accept in exchange for convenient management.
If the extension only includes simple plpgsql and sql functions you can add the functions manually. That is not possible with anything requiring superuser privileges, including any extension with C code.
jsonbx adds functions and operators. The source contains C code, so there is no way you can load this on RDS. Ever. At all. RDS doesn't allow you to run anything that might give you superuser access or access to the underlying VM that PostgreSQL runs on, nor does it provide a way to upload extensions even if it would permit you to load them.
You will need to switch to running a standalone PostgreSQL server (say, on EC2), persuade Amazon support to make the extension available as part of their supported set of extensions, or make do without.