title: Create an RDS/Postgres Replica in another AWS account?
body: <p>I have an AWS account with a Postgres RDS database that represents the production environment for an app.  We have another team that is building an analytics infrastructure in a different AWS account.  They need to be able to pull data from our production database to hydrate their reports.</p>
  
  <p>From my research so far, it seems there are a couple options:</p>
  
  <ol>
  <li><p>Create a bash script that runs on a CRON schedule that uses <code>pg_dump</code> and <code>pg_restore</code> and stash that on an EC2 instance in one of the accounts.</p></li>
  <li><p>Automate the process of creating a Snapshot on a schedule and then ship that to the other accounts S3 bucket.  Then create a Lambda (or other script) that triggers when the snapshot is placed in the S3 bucket and restore it.  Downside to this is we'd have to create a new RDS instance with each restore (since you can't restore a Snapshot to an existing instance), which changes the FQDN of the database (which we can mitigate using Route53 and a CNAME that gets updated, but this is complicated).</p></li>
  <li><p>Create a read-replica in the origin AWS account and open up security for that instance so they can just access it directly (but then my account is responsible for all the costs associated with hosting and accessing it).</p></li>
  </ol>
  
  <p>None of these seem like good options.  Is there some other way to accomplish this?</p>