Why am I seeing a server version mismatch error when restoring a Postgres database?
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
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 .