Re: pgAdmin 4 v1.3 fails to load

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:melvin6925(at)yahoo(dot)com]
Sent: Thursday, March 23, 2017 2:06 PM
To: Campbell, Lance <lance(at)illinois(dot)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" <lance(at)illinois(dot)edu<mailto:lance(at)illinois(dot)edu>>
To: Melvin Davidson <melvin6925(at)yahoo(dot)com<mailto:melvin6925(at)yahoo(dot)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' <melvin6925(at)yahoo(dot)com<mailto:melvin6925(at)yahoo(dot)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:melvin6925(at)yahoo(dot)com]
Sent: Thursday, March 23, 2017 1:20 PM
To: Campbell, Lance <lance(at)illinois(dot)edu<mailto:lance(at)illinois(dot)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" <lance(at)illinois(dot)edu<mailto:lance(at)illinois(dot)edu>>
To: marcelo <marcelo(dot)nicolet(at)gmail(dot)com<mailto:marcelo(dot)nicolet(at)gmail(dot)com>>; "pgadmin-support(at)postgresql(dot)org<mailto:pgadmin-support(at)postgresql(dot)org>" <pgadmin-support(at)postgresql(dot)org<mailto:pgadmin-support(at)postgresql(dot)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-owner(at)postgresql(dot)org<mailto:pgadmin-support-owner(at)postgresql(dot)org> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of marcelo
Sent: Thursday, March 23, 2017 11:09 AM
To: pgadmin-support(at)postgresql(dot)org<mailto:pgadmin-support(at)postgresql(dot)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-owner(at)postgresql(dot)org<mailto:pgadmin-support-owner(at)postgresql(dot)org> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Peter Johnson
Sent: Tuesday, March 21, 2017 9:57 PM
To: pgadmin-support(at)postgresql(dot)org<mailto:pgadmin-support(at)postgresql(dot)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