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.

• Managing large objects with the lo module

• Scheduling maintenance with the PostgreSQL pg_cron extension

• Managing PostgreSQL partitions with the pg_partman extension

• Working with Oracle databases by using the oracle_fdw extension

• Working with SQL Server databases by using the tds_fdw extension