Posted On: Nov 6, 2020
Amazon Aurora with PostgreSQL compatibility now supports importing data stored in Amazon Simple Storage Service (S3) buckets to PostgreSQL tables in AWS GovCloud (US) Regions. A new extension, aws_s3, has been added to perform the import operation. You can import any data format that is supported by the PostgreSQL COPY command, using the ARN role association method or using Amazon S3 credentials.
Import from Amazon S3 is supported by Amazon Aurora for PostgreSQL version 2.3, and is compatible with PostgreSQL 10.7. To learn more, please visit the documentation page.
Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora is up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. It provides the security, availability, and reliability of commercial databases at 1/10th the cost. To learn more about Amazon Aurora please see our product page and documentation.