I want to create a backup of my database in Postgres.
I'm using pgAdmin.

  • on my database I have clicked right button of mouse
  • after that I've selected the "Create a backup of database"

After that I've got a sequence of messages:

C:\Program Files\pgAdmin III\1.12\pg_dump.exe --host localhost --port 5432 --username "postgres" --role "postgres" --no-password  --verbose --file "E:\wfr.backup" "WFR"
pg_dump: server version: 9.1.1; pg_dump version: 9.0.3
pg_dump: aborting because of server version mismatch
pg_dump: *** aborted because of error

Why didn't it create a backup and return the error instead?

  • You have pgAdminIII that is compatible with PostgreSQL 9.0 but the server is PostgreSQL 9.1. Get new pgAdminIII.
    – jkj
    Jan 19, 2012 at 10:12

2 Answers 2


pgAdmin III 1.12 does not support PostgreSQL 9.1. So better upgrade your pgAdmin III to version 1.14 or newer.

  • Is there a PgAdmin IV? Could you give me a link to download it?
    – BKl
    Jan 19, 2012 at 10:29
  • I've linked to the most recent version in my answer.
    – Ilion
    Jan 19, 2012 at 10:32
  • postgresql.org/ftp/pgadmin3/release/v1.14.1/win32 here you can download..
    – vijikumar
    Jan 19, 2012 at 10:37
  • It was the fault of version of PgAdmin. When I have downloaded and installed a version which vijikumar post above, the problem disappear. Thank you all for a help!
    – BKl
    Jan 19, 2012 at 10:51

There's a difference between pg_dump on the system running pg_dump and postgres on your database server that's too big for them to be considered compatible. Find out what version of postgres is on your server and then install the same version of pg_dump locally.

The most recent version of PgAdmin will support your database. You're a couple releases behind.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.