Redshift will answer almost any question about your data, as long as the data is already there. Getting it from Postgres to Redshift is your job, and the first version is usually a nightly dump to Amazon S3 followed by COPY . That holds until an order is cancelled at noon and the evening dashboard still counts it.
The common ways to move Postgres data into Redshift:
COPY from S3 exports on a schedule. A script, a scheduler and a staging bucket. Freshness is hours to daily, and updates and deletes need full reloads or your own merge.
AWS Database Migration Service (DMS) . Change data capture (CDC) through logical replication into native Redshift tables, updates and deletes included. You run a replication instance and a task, plus an S3 staging bucket.
Aurora PostgreSQL zero-ETL integration . ETL is extract, transform, load, and here there is none to run: changes reach native Redshift tables within seconds.…