Over the last couple years Postgres Foreign Data Wrappers (FDW’s) having matured into something very powerful and complete. You can integrate with other Postgres and non-Postgres database instances natively and seamlessly. Check out this blog post from the good people at Heroku and you’ll start to understand the beauty and simplicity. The postgres_fdw data wrapper is built into standard vanilla PostgreSQL 9.3 and lets you easily federate remote Postgres instances.