PostgreSQL 9.4 database cannot be saved using pgAdmin 3 (Windows 8.1)

Question

I work with confuence on Windows 8.1 and created a lot of input there.

Now I wanted to back up my PostgreSQL 9.4 database using pgAdmin 3 .

I get an error message:

C: \ Program Files (x86) \ pgAdmin III \ 1.18 \ pg_dump.exe --host localhost --port 5432 --username "postgres" --no-password --format custom --blobs --verbose - -file " C: \ Users \ milenko \ Desktop \ output.backup "merge"

pg_dump: server version: 9.4.1; Pg_dump version: 9.3.1

pg_dump: interruption due to server version mismatch

Do you know a solution?

Answer 1

You need to tell pgAdmin to use the 9.4 binaries through the Binary Paths section in the options dialog:

http://www.pgadmin.org/docs/1.20/options-browser.html

---

Your version of pgAdmin is also a bit outdated. 1.20 ships with Postgres 9.4, not 1.18

Answer 2

It was also very useful for me to simply replace pg_dump.exe into the pgadmin version folder with my pg_dump.exe from my Postgres database.

I understand why the solution above is better, but if someone has problems with this, it also looks like a functional alternative.