Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load - Mailing list pgadmin-support

From Campbell, Lance
Subject Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load
Date
Msg-id B75CD08C73BD3543B97E4EF3964B7D7047AF532E@CITESMBX1.ad.uillinois.edu
Whole thread Raw
In response to [pgadmin-support] pgAdmin 4 v1.3 fails to load  ("Peter Johnson" <pj@acslink.net.au>)
List pgadmin-support

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@yahoo.com]
Sent: Thursday, March 23, 2017 2:06 PM
To: Campbell, Lance <lance@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.

www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com

 


From: "Campbell, Lance" <lance@illinois.edu>
To: Melvin Davidson <melvin6925@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' <melvin6925@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:melvin6925@yahoo.com]
Sent: Thursday, March 23, 2017 1:20 PM
To: Campbell, Lance <lance@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.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com

 


From: "Campbell, Lance" <lance@illinois.edu>
To: marcelo <marcelo.nicolet@gmail.com>; "pgadmin-support@postgresql.org" <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-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of marcelo
Sent: Thursday, March 23, 2017 11:09 AM
To: 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-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Peter Johnson
Sent: Tuesday, March 21, 2017 9:57 PM
To: 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

 

 

 

pgadmin-support by date:

Previous
From: "Campbell, Lance"
Date:
Subject: Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load
Next
From: "Campbell, Lance"
Date:
Subject: [pgadmin-support] pgAdmin 4 request