Обсуждение: pgAdmin 4 v1.6 Released!

The download links are wrong, the links downloads 1.5 and not 1.6.

 

Regards.

 

De: Dave Page [mailto:dpage@pgadmin.org]
Enviado el: jueves, 13 de julio de 2017 11:18 a. m.
Para: pgAdmin Support; pgadmin-hackers
Asunto: pgAdmin 4 v1.6 Released!

 

The pgAdmin Development Team are pleased to announce the release of pgAdmin 4 version 1.6. This release of pgAdmin 4 includes over 70 bug fixes and a dozen new features. For details, please see the release notes (https://www.pgadmin.org/docs/pgadmin4/dev/release_notes_1_6.html).

 

Notable changes in this release include:

 

* Significant performance improvements on Windows, massively reducing initial load time and improving UI response for the vast majority of users during testing.

 

* Enhancements to the Query Tool enabling the viewing of large query resultsets far more quickly. For example, a simple test query with 96K rows rendered results within 1 second vs. 22 seconds in pgAdmin III during testing!

 

* A major rewrite of the Query History tab allows browsing of queries executed in the query tool with full details including the entire query, in a much nicer user interface.

 

* The Desktop Runtime now supports detachable tabs, allowing the Query Tool and Debugger to be opened in new tabs and then moved to alternate displays (from 1.5 this was possible in web mode only)

 

* The Query Tool's Results Grid has been overhauled with a new, sleek look an feel supporting selection of arbitrary rows, columns or blocks of cells with full copy support and column sizing retention.

 

* The Dashboard tab can now be closed if desired, to minimise query traffic resulting from graph updates.

 

For more information, checkout the online documentation, and of course the download page: 

 

Docs: https://www.pgadmin.org/docs/pgadmin4/dev/index.html

 

Download: https://www.pgadmin.org/download

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

The download links are wrong, the links downloads 1.5 and not 1.6.

 

Regards.

 

De: Dave Page [mailto:dpage@pgadmin.org]
Enviado el: jueves, 13 de julio de 2017 11:18 a. m.
Para: pgAdmin Support; pgadmin-hackers
Asunto: pgAdmin 4 v1.6 Released!

 

The pgAdmin Development Team are pleased to announce the release of pgAdmin 4 version 1.6. This release of pgAdmin 4 includes over 70 bug fixes and a dozen new features. For details, please see the release notes (https://www.pgadmin.org/docs/pgadmin4/dev/release_notes_1_6.html).

 

Notable changes in this release include:

 

* Significant performance improvements on Windows, massively reducing initial load time and improving UI response for the vast majority of users during testing.

 

* Enhancements to the Query Tool enabling the viewing of large query resultsets far more quickly. For example, a simple test query with 96K rows rendered results within 1 second vs. 22 seconds in pgAdmin III during testing!

 

* A major rewrite of the Query History tab allows browsing of queries executed in the query tool with full details including the entire query, in a much nicer user interface.

 

* The Desktop Runtime now supports detachable tabs, allowing the Query Tool and Debugger to be opened in new tabs and then moved to alternate displays (from 1.5 this was possible in web mode only)

 

* The Query Tool's Results Grid has been overhauled with a new, sleek look an feel supporting selection of arbitrary rows, columns or blocks of cells with full copy support and column sizing retention.

 

* The Dashboard tab can now be closed if desired, to minimise query traffic resulting from graph updates.

 

For more information, checkout the online documentation, and of course the download page: 

 

Docs: https://www.pgadmin.org/docs/pgadmin4/dev/index.html

 

Download: https://www.pgadmin.org/download

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

[Narrowing the addressee list]

Hi

On Tue, Jul 18, 2017 at 11:14 PM, Pawel Hadam <hadzio@gmail.com> wrote:

Hi Dave,

Thank you for this advise.

Please find attached my files:

1) C:\Users\pawelhadam\AppData\Roaming\pgAdmin\pgadmin4.log

I cannot understand why this log file says "Starting pgAdmin 4 v1.5..." as I have installed v1.6 from pgadmin4-1.6-x86.exe

That certainly screams of 'messed up installation'. It gets that number from config.py.

 

2) C:\Program Files (x86)\pgAdmin 4\v1\web\config_local.py

I'm surprised it even works with that - it looks like a direct copy of config.py, and if you look at the end is basically importing itself.

Please uninstall pgAdmin, and ensure C:\Program Files (x86)\pgAdmin 4 is completely removed. I would also suggest removing %APPDATA%\pgAdmin as well (note that will delete your config database so you'll have to re-add any registered servers).

Then, using regedit.exe, remove the registry key: HKEY_CURRENT_USER\Software\pgadmin\pgadmin4

Once the system is completely cleaned, try a fresh installation.

Regards, Dave.

 

Thank you and kind regards

Pawel

On 17 July 2017 at 09:36, Dave Page <dpage@pgadmin.org> wrote:

On Fri, Jul 14, 2017 at 1:58 PM, Pawel Hadam <hadzio@gmail.com> wrote:

Thank you Dave and Khushboo for advises.

1) (re)moving 'pgadmin4.db' - did not help.

2) I have disabled teredo - did not help.

3) localhost is resolved to IPv6 address:

$ ping localhost

Pinging ogrodowa [::1] with 32 bytes of data:

Reply from ::1: time<1ms

Reply from ::1: time<1ms

Reply from ::1: time<1ms

Reply from ::1: time<1ms

4) I DO use IPv4 as well.

5) No entries for localhost in hosts file.

6) On which address/port the server should be listening?

$ netstat -a | grep LISTEN | grep "127.0.0.1"

  TCP    127.0.0.1:3212         ogrodowa:0             LISTENING

  TCP    127.0.0.1:3213         ogrodowa:0             LISTENING

  TCP    127.0.0.1:4370         ogrodowa:0             LISTENING

  TCP    127.0.0.1:4371         ogrodowa:0             LISTENING

  TCP    127.0.0.1:4380         ogrodowa:0             LISTENING

  TCP    127.0.0.1:4381         ogrodowa:0             LISTENING

  TCP    127.0.0.1:5037         ogrodowa:0             LISTENING

  TCP    127.0.0.1:9990         ogrodowa:0             LISTENING

  TCP    127.0.0.1:30000        ogrodowa:0             LISTENING

  TCP    127.0.0.1:49674        ogrodowa:0             LISTENING

7) ping to 127.0.0.1 works well:

$ ping 127.0.0.1

Pinging 127.0.0.1 with 32 bytes of data:

Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Not sure what else I need to check...

In the web/ subdirectory of the installation, you should find a file called config.py. Please create a file called config_local.py in the same directory, containing the following lines (excluding the ==== lines) :

====

from config import *

# Debug mode

DEBUG = True

# Log

CONSOLE_LOG_LEVEL = DEBUG

FILE_LOG_LEVEL = DEBUG

====

Then, try to start pgAdmin. That should create a more useful logfile in %APPDATA%\pgAdmin to share with us.

Thanks.

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

You don't have the PostgreSQL installer from EDB or BigSQL on that machine do you? They have their own separate copies of pgAdmin.

Sent from my iPad

On 20 Jul 2017, at 23:53, Pawel Hadam <hadzio@gmail.com> wrote:

Thank you Dave,

Full clean-up (all folders and registry) and fresh installation helps once. On the last screen I select to Launch pgAdmin4 and v1.6 starts correctly and I can use it. I need to say it is very nice.

2017-07-20 23:42:17,891: INFO pgadmin: Starting pgAdmin 4 v1.6...

However, when I exit and launch it again, it starts again.... v1.5 in the server mode and the log files say the same and it still cannot connect to the server:

2017-07-20 23:43:56,013: INFO pgadmin: Starting pgAdmin 4 v1.5...

Please see attached config files from C:\Program Files (x86)\pgAdmin 4\v1\web\ 

and log files from C:\Users\pawelhadam\AppData\Roaming\pgAdmin\

I have no idea where v1.5 is still sitting on my PC :( I must be doing something stupid, I am afraid.

Thanks in advance for any more help and kind regards

Pawel

On 19 July 2017 at 09:12, Dave Page <dpage@pgadmin.org> wrote:

[Narrowing the addressee list]

Hi

On Tue, Jul 18, 2017 at 11:14 PM, Pawel Hadam <hadzio@gmail.com> wrote:

Hi Dave,

Thank you for this advise.

Please find attached my files:

1) C:\Users\pawelhadam\AppData\Roaming\pgAdmin\pgadmin4.log

I cannot understand why this log file says "Starting pgAdmin 4 v1.5..." as I have installed v1.6 from pgadmin4-1.6-x86.exe

That certainly screams of 'messed up installation'. It gets that number from config.py.

 

2) C:\Program Files (x86)\pgAdmin 4\v1\web\config_local.py

I'm surprised it even works with that - it looks like a direct copy of config.py, and if you look at the end is basically importing itself.

Please uninstall pgAdmin, and ensure C:\Program Files (x86)\pgAdmin 4 is completely removed. I would also suggest removing %APPDATA%\pgAdmin as well (note that will delete your config database so you'll have to re-add any registered servers).

Then, using regedit.exe, remove the registry key: HKEY_CURRENT_USER\Software\pgadmin\pgadmin4

Once the system is completely cleaned, try a fresh installation.

Regards, Dave.

 

Thank you and kind regards

Pawel

On 17 July 2017 at 09:36, Dave Page <dpage@pgadmin.org> wrote:

On Fri, Jul 14, 2017 at 1:58 PM, Pawel Hadam <hadzio@gmail.com> wrote:

Thank you Dave and Khushboo for advises.

1) (re)moving 'pgadmin4.db' - did not help.

2) I have disabled teredo - did not help.

3) localhost is resolved to IPv6 address:

$ ping localhost

Pinging ogrodowa [::1] with 32 bytes of data:

Reply from ::1: time<1ms

Reply from ::1: time<1ms

Reply from ::1: time<1ms

Reply from ::1: time<1ms

4) I DO use IPv4 as well.

5) No entries for localhost in hosts file.

6) On which address/port the server should be listening?

$ netstat -a | grep LISTEN | grep "127.0.0.1"

  TCP    127.0.0.1:3212         ogrodowa:0             LISTENING

  TCP    127.0.0.1:3213         ogrodowa:0             LISTENING

  TCP    127.0.0.1:4370         ogrodowa:0             LISTENING

  TCP    127.0.0.1:4371         ogrodowa:0             LISTENING

  TCP    127.0.0.1:4380         ogrodowa:0             LISTENING

  TCP    127.0.0.1:4381         ogrodowa:0             LISTENING

  TCP    127.0.0.1:5037         ogrodowa:0             LISTENING

  TCP    127.0.0.1:9990         ogrodowa:0             LISTENING

  TCP    127.0.0.1:30000        ogrodowa:0             LISTENING

  TCP    127.0.0.1:49674        ogrodowa:0             LISTENING

7) ping to 127.0.0.1 works well:

$ ping 127.0.0.1

Pinging 127.0.0.1 with 32 bytes of data:

Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Not sure what else I need to check...

In the web/ subdirectory of the installation, you should find a file called config.py. Please create a file called config_local.py in the same directory, containing the following lines (excluding the ==== lines) :

====

from config import *

# Debug mode

DEBUG = True

# Log

CONSOLE_LOG_LEVEL = DEBUG

FILE_LOG_LEVEL = DEBUG

====

Then, try to start pgAdmin. That should create a more useful logfile in %APPDATA%\pgAdmin to share with us.

Thanks.

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

<config.py>

<pgadmin4.log>

<config_distro.py>

<config_local.py>

Hi

On Fri, Jul 21, 2017 at 9:52 PM, Pawel Hadam <hadzio@gmail.com> wrote:

Hi Dave,

I have only 2 versions of pgAdmin4.exe:

$ find . -name "pgAdmin4.exe"

./Program Files/PostgreSQL/9.6/pgAdmin 4/bin/pgAdmin4.exe

./Program Files (x86)/pgAdmin 4/v1/runtime/pgAdmin4.exe

The first one is definitely v1.3 and works well when started by running the exec itself.

When installer started v1.6, the process was pointing to the second exec.

When I start the second exec from cygwin bash it starts v1.6 - what is good, and a kind of a workaround and a kind of a hint, as well. So I added to the shortcut "Run as administrator" and now it starts v1.6 correctly. So the issue is solved - thank you Dave!

Well, that's good, but I really like to get to the bottom of things :-)

 

But where is the v1.5 that starts from the "non-administrator" shortcut, that's another question...

You could try searching for files containing one of these lines:

APP_REVISION = 5

APP_VERSION_INT = 15001

That should (I hope) find the config.py that is setup for 1.5.

 

Thanks and regards

Pawel

On 21 July 2017 at 09:27, Dave Page <dpage@pgadmin.org> wrote:

Hi

On Fri, Jul 21, 2017 at 7:14 AM, Pawel Hadam <hadzio@gmail.com> wrote:

Hi Dave,

I do have pgAdmin4 v.1.3 (not v1.5) installed with postgresql-9.6.2-3-windows-x64.exe - and it works well when started directly from its own folder.

I suspect, that those two environments may disturb each other, but cannot see see how.

No, they're designed to be completely independent. The only thing they would share would be registry settings for zoom level and geometry.

 

Also:

1) when v1.6 launched from the installer it works well.

2) when v1.6 launched from a shortcut it starts v1.5.

What does the shortcut point to for the working directory? If you run it, then press Alt+Shift+P, are there any settings shown?

 

3) When I check from program manager, both 1) and 2) run the same "pgAdmin 4\v1\runtime\pgAdmin4.exe" executable from v1.6 installation path.

I will do some checks on another PC today.

Thank you and kind regards

Pawel

On 21 July 2017 at 00:28, Dave Page <dpage@pgadmin.org> wrote:

You don't have the PostgreSQL installer from EDB or BigSQL on that machine do you? They have their own separate copies of pgAdmin.

Sent from my iPad

On 20 Jul 2017, at 23:53, Pawel Hadam <hadzio@gmail.com> wrote:

Thank you Dave,

Full clean-up (all folders and registry) and fresh installation helps once. On the last screen I select to Launch pgAdmin4 and v1.6 starts correctly and I can use it. I need to say it is very nice.

2017-07-20 23:42:17,891: INFO pgadmin: Starting pgAdmin 4 v1.6...

However, when I exit and launch it again, it starts again.... v1.5 in the server mode and the log files say the same and it still cannot connect to the server:

2017-07-20 23:43:56,013: INFO pgadmin: Starting pgAdmin 4 v1.5...

Please see attached config files from C:\Program Files (x86)\pgAdmin 4\v1\web\ 

and log files from C:\Users\pawelhadam\AppData\Roaming\pgAdmin\

I have no idea where v1.5 is still sitting on my PC :( I must be doing something stupid, I am afraid.

Thanks in advance for any more help and kind regards

Pawel

On 19 July 2017 at 09:12, Dave Page <dpage@pgadmin.org> wrote:

[Narrowing the addressee list]

Hi

On Tue, Jul 18, 2017 at 11:14 PM, Pawel Hadam <hadzio@gmail.com> wrote:

Hi Dave,

Thank you for this advise.

Please find attached my files:

1) C:\Users\pawelhadam\AppData\Roaming\pgAdmin\pgadmin4.log

I cannot understand why this log file says "Starting pgAdmin 4 v1.5..." as I have installed v1.6 from pgadmin4-1.6-x86.exe

That certainly screams of 'messed up installation'. It gets that number from config.py.

 

2) C:\Program Files (x86)\pgAdmin 4\v1\web\config_local.py

I'm surprised it even works with that - it looks like a direct copy of config.py, and if you look at the end is basically importing itself.

Please uninstall pgAdmin, and ensure C:\Program Files (x86)\pgAdmin 4 is completely removed. I would also suggest removing %APPDATA%\pgAdmin as well (note that will delete your config database so you'll have to re-add any registered servers).

Then, using regedit.exe, remove the registry key: HKEY_CURRENT_USER\Software\pgadmin\pgadmin4

Once the system is completely cleaned, try a fresh installation.

Regards, Dave.

 

Thank you and kind regards

Pawel

On 17 July 2017 at 09:36, Dave Page <dpage@pgadmin.org> wrote:

On Fri, Jul 14, 2017 at 1:58 PM, Pawel Hadam <hadzio@gmail.com> wrote:

Thank you Dave and Khushboo for advises.

1) (re)moving 'pgadmin4.db' - did not help.

2) I have disabled teredo - did not help.

3) localhost is resolved to IPv6 address:

$ ping localhost

Pinging ogrodowa [::1] with 32 bytes of data:

Reply from ::1: time<1ms

Reply from ::1: time<1ms

Reply from ::1: time<1ms

Reply from ::1: time<1ms

4) I DO use IPv4 as well.

5) No entries for localhost in hosts file.

6) On which address/port the server should be listening?

$ netstat -a | grep LISTEN | grep "127.0.0.1"

  TCP    127.0.0.1:3212         ogrodowa:0             LISTENING

  TCP    127.0.0.1:3213         ogrodowa:0             LISTENING

  TCP    127.0.0.1:4370         ogrodowa:0             LISTENING

  TCP    127.0.0.1:4371         ogrodowa:0             LISTENING

  TCP    127.0.0.1:4380         ogrodowa:0             LISTENING

  TCP    127.0.0.1:4381         ogrodowa:0             LISTENING

  TCP    127.0.0.1:5037         ogrodowa:0             LISTENING

  TCP    127.0.0.1:9990         ogrodowa:0             LISTENING

  TCP    127.0.0.1:30000        ogrodowa:0             LISTENING

  TCP    127.0.0.1:49674        ogrodowa:0             LISTENING

7) ping to 127.0.0.1 works well:

$ ping 127.0.0.1

Pinging 127.0.0.1 with 32 bytes of data:

Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Not sure what else I need to check...

In the web/ subdirectory of the installation, you should find a file called config.py. Please create a file called config_local.py in the same directory, containing the following lines (excluding the ==== lines) :

====

from config import *

# Debug mode

DEBUG = True

# Log

CONSOLE_LOG_LEVEL = DEBUG

FILE_LOG_LEVEL = DEBUG

====

Then, try to start pgAdmin. That should create a more useful logfile in %APPDATA%\pgAdmin to share with us.

Thanks.

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

<config.py>

<pgadmin4.log>

<config_distro.py>

<config_local.py>

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company