Upgrading PostgreSQL from 10.1 to 10.3

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.

1. first sudo apt-get update  (to update repository file)
2. apt-get install postgresql-10 (actual installation of binaries)
3. log into db and check “select version()”
4. Done!
5. 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!