title: Copying Postgresql DB dump from remote server to local
body: <p>I want to take a DB dump from a remote server and then copy this dump to my local.
  I tried couple of commands but didn't worked.</p>
  <p>Lastly I tried the command below;</p>
  <pre><code>pg_dump  -h 10.10.10.70 -p 5432  -U postgres -d mydb   | gzip &gt; db1.gz
  </code></pre>
  <p>I succesffully take the DB and tried with restore from Pgadmin, it gives;</p>
  <pre><code>pg_restore: error: input file appears to be a text format dump. Please use psql
  </code></pre>
  <p>But at this point I can't use psql, I have to use Pgadmin and not sure if I'm able to get successfully DB dump to my local. I mean I can't verify with restore.</p>
  <p>How can I take DB dump from remote server to my local?</p>
  <p>Thanks!</p>