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 .

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support
Terms of Service Privacy Cookies © 2019 Salesforce.com