Why am I seeing a server version mismatch error when restoring a Postgres database?

Issue

You are seeing a similar error in your console when attempting to restore a Postgres database:

pg_dump: server version: 9.6.1; pg_dump version: 9.5.6
pg_dump: aborting because of server version mismatch

Resolution

Postgres utilities such as pg_dump are not guaranteed to be forward compatible. Thus if the version of pg_dump used to create the dump file is older than the Postgres version of the target database then you will be unable to complete the restore. There are two solutions.

  • Downgrade the target Postgres version to match that version which created the dump.
  • Upgrade the source Postgres version to match the target Postgres version and re-create the dump file .