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