Posted On: May 17, 2018
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.
To use this feature, you can create a new Amazon RDS for PostgreSQL database instance with just a few clicks in the AWS Management Console. You can then configure the remote server, user, and table on the primary instance and run the read only query to the remote table from one of the read replicas. Learn more about the postgres_fdw extension from the Amazon RDS User Guide.
Amazon RDS for PostgreSQL makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. See Amazon RDS for PostgreSQL Pricing for regional availability.