pg_restore: [archiver] unsupported version (1.13) in file header error with pg_restore

[obo]

It is not possible to restore the database using the default version of pg_restore. 

The command results in error "pg_restore: [archiver] unsupported version (1.13) in file header"


Environment:

Qlik Sense June 2017 or higher

Resolution:

1. install the latest version of pgAdmin4  from www.postgresql.org
2. perform the restore using the pg_restore.exe binary from the pgAdmin  installation (default path: C:\Program Files (x86)\pgAdmin 4\v3\runtime ) instead than the one contained in C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin
   
   The command for running this from the default pgAdmin installation path would be:

"C:\Program Files (x86)\pgAdmin 4\v3\runtime\pg_restore.exe"  -h localhost -p 4432 -U postgres -d QSR "c:\QSR_backup.tar"

Cause:

The backup might have be taken with a version of pg_dump higher than the standard one included in Qlik Sense, like the one from a recent version of pgAdmin.