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?
-
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.Craig Ringer– Craig Ringer2015年08月19日 01:18:48 +00:00Commented Aug 19, 2015 at 1:18
-
@CraigRinger Can I add the extensions features as functions?Thellimist– Thellimist2015年08月19日 01:22:13 +00:00Commented Aug 19, 2015 at 1:22
2 Answers 2
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.
Currently there are a few available extensions in Amazon RDS -- detailed in the "Database Engine Features" chapter.
You can issue the following command to get the available extensions supported:
SHOW rds.extensions;
-
1Oh, it actually had the one i was looking for. Lucky meDenLilleMand– DenLilleMand2019年01月22日 14:59:54 +00:00Commented Jan 22, 2019 at 14:59
-
@DenLilleMand They use to update the list often, so you may refresh time to time to see if there are new contribs added that might be for your interest.3manuek– 3manuek2019年01月22日 15:02:05 +00:00Commented Jan 22, 2019 at 15:02
-
You can also see the list of extensions here: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/…Peter Sankauskas– Peter Sankauskas2021年03月17日 17:57:37 +00:00Commented Mar 17, 2021 at 17:57
-
The list of extensions is now found on this page: docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/…sihaya– sihaya2022年06月14日 13:45:40 +00:00Commented Jun 14, 2022 at 13:45
Explore related questions
See similar questions with these tags.