title: How to backup & Restore PostgreSQL database in Windows7?
body: <p>I am new to Postgres database. I have to get the backup from Production Server (pgAdmin Version is 9.2.4) &amp; restore it on my local machine (I have pgAdmin Version 9.4). I tried to get backup by right clicking on database -> Backup to get the .backup file. Like shown in below image:</p>
  
  <p><img src="https://i.stack.imgur.com/JBTqv.png" alt="enter image description here"></p>
  
  <p>But when I try to restore the backup file, I get many errors.</p>
  
  <p>I also want to know whether having different ports at both system can also create issues while restoring backups. As When I tried to restore backup of same system had no problems.</p>