postgresqlamazon-web-servicesamazon-s3amazon-rdsamazon-data-pipeline

Exporting a AWS Postgres RDS Table to AWS S3

I wanted to use AWS Data Pipeline to pipe data from a Postgres RDS to AWS S3. Does anybody know how this is done?

More precisely, I wanted to export a Postgres Table to AWS S3 using data Pipeline. The reason I am using Data Pipeline is I want to automate this process and this export is going to run once every week.

Any other suggestions will also work.

Solution

  • There is a sample on github. https://github.com/awslabs/data-pipeline-samples/tree/master/samples/RDStoS3

    Here is the code: https://github.com/awslabs/data-pipeline-samples/blob/master/samples/RDStoS3/RDStoS3Pipeline.json