title: Restore a remote dump to RDS
body: <p>I know how to restore a pg dump into a RDS database if that dump is in my machine, but how could I do it when the dump is available at a remote location, say Amazon S3?</p>
  
  <p>What I want to do is something like this:</p>
  
  <p><code>pg_restore -h somedomain.us-east-1.rds.amazonaws.com -p 5432 -d databasename -U username https://s3.amazonaws.com/database.dump
  </code></p>
  
  <p>But of course this results in</p>
  
  <p><code>pg_restore: [archiver] could not open input file "https://s3.amazonaws.com/database.dump"
  </code></p>
  
  <p>Thanks for your help!</p>