Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Jan 19 '12 at 20:21

This question came from our site for professional and enthusiast programmers.

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

2 Answers

up vote 2 down vote accepted

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

share|improve this answer
    
Is there a PgAdmin IV? Could you give me a link to download it? –  BKl Jan 19 '12 at 10:29
    
I've linked to the most recent version in my answer. –  Ilion Jan 19 '12 at 10:32
    
postgresql.org/ftp/pgadmin3/release/v1.14.1/win32 here you can download.. –  vijikumar Jan 19 '12 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 '12 at 10:51
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.