title: Trying to dump a PostgreSQL-10 DB running in a CentOS 7 machine and restore it into a Windows 10 machine
body: <p>I am trying to execute a backup of my PostgreSQL-10 database running on a CentOS 7 machine and then to restore it in a development machine running Windows 10, but I am getting errors during the restore process:</p>
  
  <pre><code>pg_restore: [custom archiver] WARNING: ftell mismatch with expected position -- ftell used
  </code></pre>
  
  <p>I have made sure that the commands' parameters passed in both dump and restore are the same:</p>
  
  <pre><code>pg_dump --format=c --compress=9 --encoding=UTF-8 -n public --verbose --username=postgres databaseName -W -f /usr/local/production-dump.backup
  </code></pre>
  
  <p>However it does not work at all. Even though the schema is restored, the data is not, because right before the restore process is going to start restoring data, it gives a "pipe has ended" error and does not proceed with the full restore process. I am using the "custom" format because the plain SQL or tar formats generate huge backup files.</p>
  
  <p>What am I doing wrong? Is there any parameter that I need to pass to the dump or restore commands?</p>