Thanks, Ray! That was it. Lou
-----Original Message----- From: Raymond O'Donnell [mailto:r...@iol.ie] Sent: Wednesday, October 01, 2014 12:11 PM To: Lou Oquin; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] 2 Server Versions, problem with backup from pgAdmin On 01/10/2014 17:50, Lou Oquin wrote: > 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 It's in the options: File -> Options -> Browser -> Binary paths. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
