Skip to content

Instantly share code, notes, and snippets.

@joshuaflanagan
Created November 16, 2013 02:15
Show Gist options
  • Save joshuaflanagan/7495006 to your computer and use it in GitHub Desktop.
Save joshuaflanagan/7495006 to your computer and use it in GitHub Desktop.
Postgres extensions on Amazon RDS
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)
@jeremywadsack
Copy link

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

@mattghali
Copy link

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

@The-Alchemist
Copy link

The-Alchemist commented Oct 2, 2017

@christiaanwesterbeek
Copy link

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!

@nagaraju11
Copy link

Does aurora postgres supports pgcrypto extension ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment