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

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 .