# How to stream PostgreSQL changes to Amazon S3 with AWS Fargate

DevFeed: [How to stream PostgreSQL changes to Amazon S3 with AWS Fargate](<https://devfeed.tech/articles/how-to-stream-postgresql-changes-to-amazon-s3-with-aws-fargate-60175.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/how-to-stream-postgresql-changes-to-amazon-s3-with-aws-fargate/>)

Author: Ramdas Gutlapalli

Published: 2026-09-25T16:25:06Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [AWS Fargate](<https://devfeed.tech/topics/aws-fargate.md>), [event driven](<https://devfeed.tech/topics/event-driven.md>), [AWS CloudFormation](<https://devfeed.tech/topics/aws-cloudformation.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon EventBridge](<https://devfeed.tech/topics/amazon-eventbridge.md>), [Amazon Simple Queue Service (SQS)](<https://devfeed.tech/topics/amazon-simple-queue-service-sqs.md>), [AWS Lambda](<https://devfeed.tech/topics/aws-lambda.md>)

Tags: [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-eventbridge](<https://devfeed.tech/tags/amazon-eventbridge.md>), [amazon-s3](<https://devfeed.tech/tags/amazon-s3.md>), [amazon-simple-storage-service-s3](<https://devfeed.tech/tags/amazon-simple-storage-service-s3.md>), [amazon-sqs](<https://devfeed.tech/tags/amazon-sqs.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-cloudformation](<https://devfeed.tech/tags/aws-cloudformation.md>), [aws-fargate](<https://devfeed.tech/tags/aws-fargate.md>), [aws-lambda](<https://devfeed.tech/tags/aws-lambda.md>), [change-data-capture](<https://devfeed.tech/tags/change-data-capture.md>), [expert-400](<https://devfeed.tech/tags/expert-400.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-compatible](<https://devfeed.tech/tags/postgresql-compatible.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

## AI overview

A tutorial for building a managed, event-driven change data capture pipeline that streams PostgreSQL row-level changes from Amazon RDS or Aurora PostgreSQL to Amazon S3 near real time. The pipeline uses Fargate, EventBridge, SQS, Lambda, and CloudFormation, with S3 records stored as partitioned JSON files.

## Source excerpt

In this post, we show you how to build a fully managed, event-driven change data capture (CDC) pipeline. It streams row-level changes from Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL to Amazon S3 in near real time. You deploy the entire pipeline with a single AWS CloudFormation template, and it can run in private subnets with no internet gateway without exposing resources to the public internet.