Sync data from Redshift to PostgreSQL

by

Want to sync data from Redshift to PostgreSQL ?

Try Withdata DBCopier, a Redshift to PostgreSQL converter for Windows, Mac, and Linux, Synchronize Redshift to PostgreSQL, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Synchronize data from Redshift to PostgreSQL

Login to Redshift and target PostgreSQL -> Select source Redshift tables -> Set target PostgreSQL tables -> Sync Redshift data to PostgreSQL

Choose source Redshift database and logon.

sync Redshift to PostgreSQL - Choose Redshift and logon

Choose target PostgreSQL database and logon.

sync Redshift to PostgreSQL - Choose PostgreSQL and logon

Click “Wizard – Import All Tables” at task dialog.

sync from Redshift to PostgreSQL - Task Window

then show the wizard.

1. Select source Redshift tables to sync.

sync from Redshift to PostgreSQL - Open source database

2. List target PostgreSQL tables.

Set “Import Type” to “Replace”, it will do a full synchronization.

sync data from Redshift to PostgreSQL - full synchronization

Or set “Import Type” to “Upsert”, it will do a upsert synchronization.

sync data from Redshift to PostgreSQL - upsert synchronization

3. Select PostgreSQL tables to sync.

sync from Redshift to PostgreSQL - select tables

4. Sync Redshift data to PostgreSQL.

sync from Redshift to PostgreSQL - sync


More about Redshift to PostgreSQL converter

See also: