9

I tried to make a backup with Postgres 11.1 in pgAdmin4, but it failed. pgadmin displayed a window with

Status: Failed (exit code: 1).

pg_dump:server version: 11.1; pg_dump: 10.5

pg_dump: aborting because of server mismatch

I don't really understand it. Does pgadmin4 not know that I am using 11.1 and not 10.5?

PROBLEM SOLVED - IN MY CASE.

Go to

pgadmin < Preferences < Path < Binary Path

The PostgreSQL Binary Path was set automatically to $DIR/../runtime

I changed the Path to my installed PostgreSQL Version C:\Program Files\PostgreSQL\11\bin

black_hole_sun
  • 908
  • 11
  • 41
  • THANK YOU @black_hole_sun for going back and updating your question with the answer as I was going nuts trying to figure out WHY the newest version of PGAgmin4 which support v15 of the DB couldn't dump a v14.7 DB. It was still using my v13 BIN.. – Scott Milella Mar 15 '23 at 21:43

1 Answers1

1

Your pgAdmin is using PostgresSQL client v10, but your server is v11.

Since v10 cannot know how to correctly dump a v11 database, it refuses to try.

Use a more recent version of pgAdmin!

Laurenz Albe
  • 209,280
  • 17
  • 206
  • 263
  • Thanks. For an answer. I use the lastest Version of pgadmin4 v.3.6 (released Nov. 29, 2018). So then i install PostgresSQL10.0 – black_hole_sun Dec 06 '18 at 22:10
  • Hmm, I'd be surprised if the latest version of pgAdmin 4 didn't support PostgreSQL v11. Perhaps it is accidentally picking up a wrong `pg_dump` that's somewhere on your `PATH`? – Laurenz Albe Dec 06 '18 at 22:47
  • sorry, what you mean with PATH? Is it possible to choose different PostgresSQL clients versions in pgAdmin? – black_hole_sun Dec 07 '18 at 17:26
  • I don't know enough about pgAdmin to answer that. Perhaps I should delete my answer, since it points out the immediate cause of the problem, but fails to explain *how* that can happen or what to do against it. – Laurenz Albe Dec 07 '18 at 18:44
  • 1
    "Perhaps I should delete my answer," Identifying the problem is the first step for a good solution. No need to delete, Laurenz. – black_hole_sun Dec 08 '18 at 19:44
  • Alright. Now it worked. Go To --> pgAdmin4 < Preferences < Path < Binary path. In my case the "PostgreSQL Binary Path" was set to "$DIR/../runtime" i changed it to the my installed version "C:\Program Files\PostgreSQL\11\bin" – black_hole_sun Dec 09 '18 at 18:06