That is interesting. If I edit that box it says:
C:\Program Files (x86)\pgAdmin III\1.22 I went into this folder and found that it only contains one backup version of pg_backup.exe. It must be for PostgreSQL 9.5.x . To test my theory I opened a command prompt and ran pg_dump.exe –version . I got this as output: pg_dump (PostgreSQL) 9.5.5 . So I am going to guess that all I need to do is install PostgreSQL version 9.6 for windows on my local box. Then point pgAdmin3 to the bin folder for 9.6. Then when I connect to my linux server remotely it will work. All of this worked. I can now backup my PostgreSQL 9.6 database with pgAdmin 3. Thanks for your help. Lance From: Melvin Davidson [mailto:melvin6...@yahoo.com] Sent: Thursday, March 23, 2017 2:06 PM To: Campbell, Lance <la...@illinois.edu> Subject: Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load >pg_dump: server version: 9.6.1; pg_dump version: 9.5.5 >pg_dump: aborting because of server version mismatch This error points to a server mismatch. IOW, you are trying to back up a 9.5 DB with a 9.6 binary. So in File, Options..., Browser, Binary Paths Change PG bin path to point to the 9.5 binary location Then you should be able to back up your 9.5 db. Change it back for 9.6 backup Note: you can also try just checking "Ignore server/utility version mismatches" Melvin Davidson 🎸 Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. [http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif] www.youtube.com/unusedhero/videos<http://www.youtube.com/unusedhero/videos> Folk Alley - All Folk - 24 Hours a day www.folkalley.com<http://www.folkalley.com> ________________________________ From: "Campbell, Lance" <la...@illinois.edu<mailto:la...@illinois.edu>> To: Melvin Davidson <melvin6...@yahoo.com<mailto:melvin6...@yahoo.com>> Sent: Thursday, March 23, 2017 2:33 PM Subject: RE: [pgadmin-support] pgAdmin 4 v1.3 fails to load I should have also included this: pg_dump: server version: 9.6.1; pg_dump version: 9.5.5 pg_dump: aborting because of server version mismatch Process returned exit code 1. From: Campbell, Lance Sent: Thursday, March 23, 2017 1:32 PM To: 'Melvin Davidson' <melvin6...@yahoo.com<mailto:melvin6...@yahoo.com>> Subject: RE: [pgadmin-support] pgAdmin 4 v1.3 fails to load With pgAdmin 3 I got this error while attempting a backup of a table: pg_dump: server version: 9.6.1; pg_dump version: 9.5.5 Do you not get this type of error on your install of pgAdmin 3? Lance From: Melvin Davidson [mailto:melvin6...@yahoo.com] Sent: Thursday, March 23, 2017 1:20 PM To: Campbell, Lance <la...@illinois.edu<mailto:la...@illinois.edu>> Subject: Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load Lance I am using PgAdmin 3 with PostgreSQL 9.6 on WIN 10 32 bit. >PGAdmin 3 will not work with PostgreSQL 9.6. What is the exact problem/error you are seeing? Melvin Davidson 🎸 Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. [http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif] www.youtube.com/unusedhero/videos<http://www.youtube.com/unusedhero/videos> Folk Alley - All Folk - 24 Hours a day www.folkalley.com<http://www.folkalley.com/> ________________________________ From: "Campbell, Lance" <la...@illinois.edu<mailto:la...@illinois.edu>> To: marcelo <marcelo.nico...@gmail.com<mailto:marcelo.nico...@gmail.com>>; "pgadmin-support@postgresql.org<mailto:pgadmin-support@postgresql.org>" <pgadmin-support@postgresql.org<mailto:pgadmin-support@postgresql.org>> Sent: Thursday, March 23, 2017 2:12 PM Subject: Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load Marcelo, I upgraded my PostgreSQL database from 9.5 to 9.6. PGAdmin 3 will not work with PostgreSQL 9.6. Lance From: pgadmin-support-ow...@postgresql.org<mailto:pgadmin-support-ow...@postgresql.org> [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of marcelo Sent: Thursday, March 23, 2017 11:09 AM To: pgadmin-support@postgresql.org<mailto:pgadmin-support@postgresql.org> Subject: Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load What is so important to switch from pgAdmin 3 to 4? I'downloaded from sourceforge something called "pgAdmin3-portable" and it works ok on Win 8.1 64 bits (but as a 32 bit app, I think) and connects without trouble with a 9.4 backend running on Linux. On 23/03/17 11:12, Campbell, Lance wrote: Peter, Have you heard of any solution to this problem. I have found pgAdmin 4 v1.3 is completely unusable on Windows 7 64 bit. I have found that pgAdmin 4 v1.1 is stable. I am currently using that version. Do you think they are not testing at all on Windows 7 64 bit? There website says it is available for Windows 7 (desktop). I wonder if they have been testing it against Windows 10 but have not updated their web site. Lance Campbell University of Illinois From: pgadmin-support-ow...@postgresql.org<mailto:pgadmin-support-ow...@postgresql.org> [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Peter Johnson Sent: Tuesday, March 21, 2017 9:57 PM To: pgadmin-support@postgresql.org<mailto:pgadmin-support@postgresql.org> Subject: [pgadmin-support] pgAdmin 4 v1.3 fails to load Hello, At start up the program window opens & displays “Loading pgAdmin 4 v1.3”. Case 1: Sometimes displays error msg: error loading script /browser/role/module.js Error msg: undefined or error loading script /debugger/js/direct Error msg: undefined and never completes loading Case 2: Sometimes does not display any error msg but never completes loading. Case 3: If I start the program with ‘Run as Administrator’, sometimes it completes loading OK & works fine, other times I get Case 2 behaviour. The debug log has repeated msgs: [0322/131833:WARNING:resource_bundle.cc(311)] locale_file_path.empty() for locale OS = Win 7 SP1 64 bit desktop mode?? I’m running the downloaded executable Steps required to reproduce the problem: run the pgAdmin 4 v1.3 executable. I would appreciate any guidance on how to fix this issue. Kind regards, Peter Johnson
