Postgres extensions on Amazon RDS

gistfile1.txt

          name          | default_version | installed_version |                               comment                               
------------------------+-----------------+-------------------+---------------------------------------------------------------------
 pg_buffercache         | 1.0             |                   | examine the shared buffer cache
 earthdistance          | 1.0             |                   | calculate great-circle distances on the surface of the Earth
 pg_freespacemap        | 1.0             |                   | examine the free space map (FSM)
 intagg                 | 1.0             |                   | integer aggregator and enumerator (obsolete)
 plperl                 | 1.0             |                   | PL/Perl procedural language
 sslinfo                | 1.0             |                   | information about SSL certificates
 btree_gist             | 1.0             |                   | support for indexing common datatypes in GiST
 fuzzystrmatch          | 1.0             |                   | determine similarities and distance between strings
 dblink                 | 1.1             |                   | connect to other PostgreSQL databases from within a database
 postgis_topology       | 2.1.0           |                   | PostGIS topology spatial types and functions
 plpgsql                | 1.0             | 1.0               | PL/pgSQL procedural language
 pgstattuple            | 1.1             |                   | show tuple-level statistics
 uuid-ossp              | 1.0             | 1.0               | generate universally unique identifiers (UUIDs)
 hstore                 | 1.2             |                   | data type for storing sets of (key, value) pairs
 pltcl                  | 1.0             |                   | PL/Tcl procedural language
 pgcrypto               | 1.0             |                   | cryptographic functions
 postgis_tiger_geocoder | 2.1.0           |                   | PostGIS tiger geocoder and reverse geocoder
 cube                   | 1.0             |                   | data type for multidimensional cubes
 postgres_fdw           | 1.0             |                   | foreign-data wrapper for remote PostgreSQL servers
 pg_stat_statements     | 1.1             |                   | track execution statistics of all SQL statements executed
 dict_xsyn              | 1.0             |                   | text search dictionary template for extended synonym processing
 intarray               | 1.0             |                   | functions, operators, and index support for 1-D arrays of integers
 tsearch2               | 1.0             |                   | compatibility package for pre-8.3 text search functions
 citext                 | 1.0             |                   | data type for case-insensitive character strings
 tablefunc              | 1.0             |                   | functions that manipulate whole tables, including crosstab
 pgrowlocks             | 1.1             |                   | show row-level locking information
 btree_gin              | 1.0             |                   | support for indexing common datatypes in GIN
 postgis                | 2.1.0           |                   | PostGIS geometry, geography, and raster spatial types and functions
 ltree                  | 1.0             |                   | data type for hierarchical tree-like structures
 chkpass                | 1.0             |                   | data type for auto-encrypted passwords
 unaccent               | 1.0             |                   | text search dictionary that removes accents
 pg_trgm                | 1.1             |                   | text similarity measurement and index searching based on trigrams
 isn                    | 1.0             |                   | data types for international product numbering standards
 dict_int               | 1.0             |                   | text search dictionary template for integers
(34 rows)

Note that not all of these are supported by RDS:

=> SHOW rds.extensions;
                                                                                                                                 rds.extensions                                                                                             

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------
 btree_gin,btree_gist,chkpass,citext,cube,dblink,dict_int,dict_xsyn,earthdistance,fuzzystrmatch,hstore,intagg,intarray,isn,ltree,pgcrypto,pgrowlocks,pg_trgm,plperl,plpgsql,pltcl,postgis,postgis_tiger_geocoder,postgis_topology,sslinfo,ta
blefunc,tsearch2,unaccent,uuid-ossp

Have you had any luck getting plpgsql working in RDS? I'm blocked on extension ownership.

Newest list of PostgreSQL RDS extensions at http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions

Wow, it's 55 extensions now. Not 34. Really check out the link mentioned above. I was happy to find out I can now type javascript inside of Postgres functions!

Does aurora postgres supports pgcrypto extension ?