pg_restore: [archiver] unsupported version (1.13) in file header error with pg_restore
Article Number: 000052287 | Last Modified: 2019/09/06
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"
Qlik Sense June 2017 or higher
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.
- install the latest version of pgAdmin4 from www.postgresql.org
- 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"