# AWS - postgres to postgres - how to?

**URL:** <https://discourse.getdbt.com/t/aws-postgres-to-postgres-how-to/2529>\
**Category:** Archive\
**Created:** [May 18, 2021, 2:07pm UTC](https://discourse.getdbt.com/t/aws-postgres-to-postgres-how-to/2529 "2021-05-18T14:07:01Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![smashmirror](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/smashmirror/32/722_2.png) [@smashmirror](https://discourse.getdbt.com/u/smashmirror)\
**Post date:** [May 18, 2021, 2:07pm UTC](https://discourse.getdbt.com/t/aws-postgres-to-postgres-how-to/2529/1 "2021-05-18T14:07:01Z")

</div>

I’m looking to use DBT for a load and transform of data from a transactional postgres database to a simple DWH in a separate postgres instance.

The transactional db is a postgres instance running on its own server, whereas the DWH will be an RDS instance.

What would be the best way to connect the 2 with transforms etc. all don by DBT in the middle?