Обсуждение: 2 Server Versions, problem with backup from pgAdmin

<div class="WordSection1"><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Ihave Windows 7 machine, with pg version
9.2.7installed, listening on 5432.  (pgAdmin, version 1.16.1)  It is installed at </span><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">C:\ProgramFiles\PostgreSQL\9.2</span><p
class="MsoNormal"><spanstyle="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><p
class="MsoNormal"><spanstyle="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Recently, I installed
(added)pg version 9.3.3, listening on port 5433.  (pgAdmin, version 1.18.1)  It is installed at</span><p
class="MsoNormal"><spanstyle="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">C:\Program
Files\PostgreSQL\9.3</span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Bothservers running and appear to be behaving
normally.</span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">However,when I try to back up a table from
withinthe 9.3 pgAdmin (v1.18.1) the table backup fails, woth the following message:</span><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">C:/Program
Files/PostgreSQL/9.2/bin\pg_dump.exe--host localhost --port 5433 --username "postgres" --role "postgres" --no-password 
--formatplain --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"</span><p
class="MsoNormal"><spanstyle="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">pg_dump: server
version:9.3.3; pg_dump version: 9.2.7</span><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">pg_dump:aborting because of server version
mismatch</span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Processreturned exit code 1.</span><p
class="MsoNormal"><spanstyle="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><p
class="MsoNormal"><spanstyle="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><p
class="MsoNormal"><spanstyle="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">What this tells me is
thatthe NEW version of pgAdmin is using the OLD version’s  pgDump.</span><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">However,I can’t locate where this is
defined. I checked the registry; Base Directory (for both) points to the correct folder</span><p
class="MsoNormal"><spanstyle="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><p
class="MsoNormal"><spanstyle="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Would appreciate any
pointersto correct this issue</span><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Thanks</span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">LouO’Quin</span></div> 

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
rod@iol.ie

Thanks, Ray!  That was it.

Lou

-----Original Message-----
From: Raymond O'Donnell [mailto:rod@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
rod@iol.ie