pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4

On 11/28/20 8:12 AM, mark armon wrote:

OS: Windows
issue:
https://stackoverflow.com/questions/14168920/how-to-fix-pg-dump-version-mismatch-errors
<https://stackoverflow.com/questions/14168920/how-to-fix-pg-dump-version-mismatch-errors&gt;

|pg_dump: error: server version: 13.0; pg_dump version: 12.4 pg_dump:
error: aborting because of server version mismatch |

You are trying to dump a Postgres 13.0 version instance using the 12.4
version of pg_dump. That will not work as the error says. You need to
find and use the 13.0 version of pg_dump and use that. FYI, it will
work the other way e.g. a newer version of pg_dump can dump an older
version of Postgres.

--
Adrian Klaver
adrian.klaver@aklaver.com

where to get pg_dump 13.0?

On Sat, Nov 28, 2020 at 9:47 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

Download postgres 13. pg dump 13 will be downloaded along with it

On Sun, Nov 29, 2020 at 11:02 AM mark armon <1994hejian@gmail.com> wrote:

On 11/28/20 9:32 PM, mark armon wrote:

where to get pg_dump 13.0?

Are both Postgres instances(12.4 and 13.0) on the same machine?

If they are and you used the EDB installer the binaries(pg_dump for
instance) will be under:

C:\Program File\PostgreSQL\<version_number>\bin

If they are not then you will either have to use the version 13 of
pg_dump that is on the other machine or install version 13 of Postgres
on your machine.

Also be aware that if you are trying to dump a version 13 instance and
restore it to a version 12 instance of Postgres you will probably have
issues beyond that of the pg_dump version. The dump/restore process is
not designed to go backwards.

On Sat, Nov 28, 2020 at 9:47 PM Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:

On 11/28/20 8:12 AM, mark armon wrote:

OS: Windows
issue:

https://stackoverflow.com/questions/14168920/how-to-fix-pg-dump-version-mismatch-errors
<https://stackoverflow.com/questions/14168920/how-to-fix-pg-dump-version-mismatch-errors&gt;

<https://stackoverflow.com/questions/14168920/how-to-fix-pg-dump-version-mismatch-errors
<https://stackoverflow.com/questions/14168920/how-to-fix-pg-dump-version-mismatch-errors&gt;&gt;

|pg_dump: error: server version: 13.0; pg_dump version: 12.4

pg_dump:

error: aborting because of server version mismatch |

You are trying to dump a Postgres 13.0 version instance using the 12.4
version of pg_dump. That will not work as the error says. You need to
find and use the 13.0 version of pg_dump  and use that. FYI, it will
work the other way e.g. a newer version of pg_dump can dump an older
version of Postgres.

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com