Working with extensions and foreign data wrappers
To add some types of functionality to your Aurora PostgreSQL-Compatible Edition DB cluster, you can install
and use various PostgreSQL extensions. For example, if your use case calls for intensive
data entry across very large tables, you can install the pg_partman
extension to partition your data and thus spread the workload. An extension that provides
access to external data is generally known as a foreign data wrapper
(FDW). As one example, the oracle_fdw
extension allows your Aurora PostgreSQL DB
cluster to work with Oracle databases.
Following, you can find information about setting up and using some of the extensions and FDWs available for Aurora PostgreSQL. For listings of the extensions and FDWs that you can use with currently available Aurora PostgreSQL versions, see Extension versions for Aurora PostgreSQL-Compatible Edition in the Release Notes for Aurora PostgreSQL.