Thread: pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4
OS: Windows
issue: 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
Re: pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4
From
Adrian Klaver
Date:
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> > > |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
Re: pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4
From
mark armon
Date:
where to get pg_dump 13.0?
On Sat, Nov 28, 2020 at 9:47 PM Adrian Klaver <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>
>
> |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
Re: pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4
From
Hemil Ruparel
Date:
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:
where to get pg_dump 13.0?On Sat, Nov 28, 2020 at 9:47 PM Adrian Klaver <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>
>
> |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
Re: pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4
From
Adrian Klaver
Date:
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> > > > > <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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > -- Adrian Klaver adrian.klaver@aklaver.com