From: | Lou Oquin <LOquin(at)nammotalley(dot)com> |
---|---|
To: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | 2 Server Versions, problem with backup from pgAdmin |
Date: | 2014-10-01 16:50:37 |
Message-ID: | ED2FDA515391AF4C99E5C8847113CB7125CF6301@NAMEEX01.talleyds.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
I have Windows 7 machine, with pg version 9.2.7 installed, listening on 5432. (pgAdmin, version 1.16.1) It is installed at
C:\Program Files\PostgreSQL\9.2
Recently, I installed (added) pg version 9.3.3, listening on port 5433. (pgAdmin, version 1.18.1) It is installed at
C:\Program Files\PostgreSQL\9.3
Both servers running and appear to be behaving normally.
However, when I try to back up a table from within the 9.3 pgAdmin (v1.18.1) the table backup fails, woth the following message:
C:/Program Files/PostgreSQL/9.2/bin\pg_dump.exe --host localhost --port 5433 --username "postgres" --role "postgres" --no-password --format plain --section pre-data --section data --section post-data --encoding UTF8 --inserts --verbose --quote-all-identifiers --file "G:\Data\apothecary_backup_20141001a.sql" --table "public.apothecary" "postgres"
pg_dump: server version: 9.3.3; pg_dump version: 9.2.7
pg_dump: aborting because of server version mismatch
Process returned exit code 1.
What this tells me is that the NEW version of pgAdmin is using the OLD version’s pgDump.
However, I can’t locate where this is defined. I checked the registry; Base Directory (for both) points to the correct folder
Would appreciate any pointers to correct this issue
Thanks
Lou O’Quin
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2014-10-01 19:10:58 | Re: 2 Server Versions, problem with backup from pgAdmin |
Previous Message | Guillaume Lelarge | 2014-10-01 11:54:19 | Re: log_error_verbosity |