If you want to synchronize your postgres db (and a lot of other things) to redshift, we do it as a service at fivetran.com