From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | mark armon <1994hejian(at)gmail(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4 |
Date: | 2020-11-29 16:22:51 |
Message-ID: | 02e6bf00-b512-46d8-a4fc-4aa11dcb9d35@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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>
>
> >
> <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>>
> >
> > |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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Goodson | 2020-11-29 18:06:03 | "Server versions prior to 8.0 do not support savepoints" when using JDBC ... |
Previous Message | Daniele Varrazzo | 2020-11-29 11:08:17 | Re: How to debug authentication issues in Postgres |