Create an IAM policy with the least-restricted privilege to the resources in the following code and name it aurora-s3-access-pol.Create the required Identity and Access Management (IAM) policies and roles:.You can also use the pgAdmin tool or tool of your choice for this purpose. Launch an Amazon EC2 instance that you installed the PostgreSQL client on.
Note: To export data to Amazon S3 from Aurora PostgreSQL, your database must be running one of the following PostgreSQL engine versions 10.14 or higher, 11.9 or higher ,12.4 or higher Launch an Aurora PostgreSQL DB cluster.The following diagram illustrates the solution architecture.īefore you get started, complete the following prerequisite steps: This means customers of all sizes and industries can use it to store and protect any amount of data. It combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open-source databases.Īmazon S3 is an object storage service that offers industry-leading scalability, data availability, security, and performance. Overview of Aurora PostgreSQL-Compatible and Amazon S3Īurora is a MySQL-compatible and PostgreSQL-compatible relational database built for the cloud.
The feature to export and import data to Amazon S3 is also available for Amazon Aurora MySQL-Compatible Edition. This post demonstrates how you can export and import data from Amazon Aurora PostgreSQL-Compatible Edition to Amazon Simple Storage Service (Amazon S3) and shares associated best practices. Aurora makes it easy to set up, operate, and scale a relational database in the cloud. Amazon Aurora is the preferred choice for OLTP workloads. You can build highly distributed applications using a multitude of purpose-built databases by decoupling complex applications into smaller pieces, which allows you to choose the right database for the right job.