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

postgresql pgadmin
len picture len · Mar 5, 2015 · Viewed 17.5k times · Source

I am working with confuence under Windows 8.1 and have produced a lot of Input there.

Now I wanted to backup my PostgreSQL 9.4 database with pgAdmin 3.

I get the error:

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" "confluence"

pg_dump: server version: 9.4.1; pg_dump version: 9.3.1

pg_dump: aborting because of server version mismatch

Do you know a solution?

Answer

a_horse_with_no_name picture a_horse_with_no_name · Mar 5, 2015

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

https://www.pgadmin.org/docs/pgadmin3/1.22.2/options-browser.html

your pgAdmin version is a bit old as well. 1.20 ships with Postgres 9.4, not 1.18

Related questions

Postgresql: password authentication failed for user "postgres"

I have installed PostgreSQL 8.4, Postgres client and Pgadmin 3. Authentication failed for user "postgres" for both console client and Pgadmin. I have typed user as "postgres" and password "postgres", because it worked before. But now authentication is failed. I did it …

Read More
How connect Postgres to localhost server using pgAdmin on Ubuntu?

I installed Postgres with this command sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev Using psql --version on terminal I get psql (PostgreSQL) 9.3.4 then I installed pgadmin with sudo apt-get install pgadmin3 Later I opened the UI and create the server …

Read More
Export and import table dump (.sql) using pgAdmin

I have pgAdmin version 1.16.1 So, for exporting table dumm I do: Right click on table, then in menu click on backup, then in Format choice Plain and save file as some_name.sql Then I remove table. Ok, now I …

Read More