PostgreSQL read replicas on Amazon RDS now support Outbound Network Access and can execute queries using the postgres_fdw extension to access remote servers. The postgres_fdw extension lets you access and modify data stored in other PostgreSQL servers as if they were tables within the RDS for PostgreSQL DB instance. This is already supported on primary PostgreSQL instances, but offloading read only queries from remote servers to read replicas will reduce resource usage on the primary instance.

Google+