After upgrading PgAdmin4 V2 to V3, I start receiving this annoying message
pg_restore: [archiver] unsupported version (1.13) in file header
Therefore started the migration process, which is a lot easier than I thought 🙂
Below assumes you’re already on PG 10.1 therefore upgrading to 10.3 doesn’t require any dump/restore.
- first sudo apt-get update (to update repository file)
- apt-get install postgresql-10 (actual installation of binaries)
- log into db and check “select version()”
- Of course you may want to download the latest Postgresql from the official site and replace those binaries packaged by pgAdmin (normally under C:\Program Files (x86)\pgAdmin 4\pgsqlbin\bin) . For some reason, it seems pgAdmin guys didn’t package the correct binaries which caused the above error!