pgAdmin is a great GUI tool to use for managing PostgreSQL databases and can be obtained here. pgAdmin will run on Windows, Linux(CentOS, SUSE, Debian, etc.), Solaris, FreeBSD, or Mac OSX.
After upgrading pgAdmin I was getting an error using the backup feature. The specific error is pasted below.
C:\Program Files\pgAdmin III\1.8\pg_dump.exe -h 10.0.0.1 -p 5432 -U postgres -F c -b -v -f "C:\databases\data_09-08-08.pgsql.backup" postgres pg_dump: server version: 8.3.3; pg_dump version: 8.3.0 pg_dump: aborting because of version mismatch (Use the -i option to proceed anyway.) pg_dump: *** aborted because of error Process returned exit code 1.
The error is exactly what it claims to be. On my local machine I also had PostgreSQL version 8.3.3 installed so I looked for pg_dump.exe and pg_dumpall.exe in the PostreSQL bin directory(C:\Program Files\PostgreSQL\8.3\bin). I replaced those two files in the pgAdmin directory(C:\Program Files\pgAdmin III\1.8\) which resolved the problem.
The main thing to consider here is the fact that your pg_dump.exe and pg_dumpall.exe must be the same version as the server you are connecting to via the pgAdmin GUI.
**NOTE** It is much quicker to use the CLI to backup PostgreSQL databases than the pgAdmin GUI. Using the below command and switches you can backup your database locally onto a linux server and then scp it to the off site server. This also helps if you do not provide access from outside your local LAN via pg_hba.conf.
pg_dump -U username -W password -f filename db_name