title: Postgresql database read only mirror
body: <p>What I need is basically to create read-only mirror of remote database on my local computer. It would be also neat if the mirror would be able to periodically update itself.</p>
  
  <p>Version of the database is <code>Postgresql 9.3</code>. </p>
  
  <p>The reason for doing this is that I need to perform selects to that database and on my internet connection it takes ages.</p>
  
  <p>I have found <a href="http://www.rassoc.com/gregr/weblog/2013/02/16/zero-to-postgresql-streaming-replication-in-10-mins/" rel="nofollow">this article</a> but it requires access to that remote server which I currently do not have. So is there some way of doing it without having direct access to the server? What I have is only db name, domain, port, username and password.</p>