title: How to create read replicas from multiple postgres databases into a single database?
body: <p><em>I'd like to preface this by saying I'm not a DBA, so sorry for any gaps in technical knowledge.</em></p>
  
  <p>I am working within a microservices architecture, where we have about a dozen or applications, each supported by its Postgres database instance (which is in RDS, if that helps). Each of the microservices' databases contains a few tables. It's safe to assume that there's no naming conflicts across any of the schemas/tables, and that there's no sharding of any data across the databases.</p>
  
  <p>One of the issues we keep running into is wanting to analyze/join data across the databases. Right now, we're relying on a 3rd Party tool that caches our data and makes it possible to query across multiple database sources (via the shared cache).</p>
  
  <p>Is it possible to create read-replicas of the schemas/tables from all of our production databases and have them available to query in a single database?</p>
  
  <p>Are there any other ways to configure Postgres or RDS to make joining across our databases possible?</p>