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

Question

im trying to restore a table from a backup file with pg_restore. However i get the error mentioned above. I read everywhere that an upgraded version of postgres is needed. I upgraded mine to 9.6.8-1 and then 10.3-1. Both did not work. Does anybody have a detailed procedure to fix this problem using a windows OS? Thanks in advance

Answer 1

Solved for me -

I had the same error restoring from PgAdmin4 on a computer with multiple Postgrsql versions installed. It was calling an older pg_restore version. In PgAdmin I changed the binary path in File/Preferences/Binary Path from $DIR/../runtime to C:\Program Files\PostgreSQL\10\bin and that fixed my issue. I suspect your having a similar issue at which you are unknowingly calling an older pg_restore version even though you updated postgresql.