Re: pgAdmin 4 v4.9 released

Hi pgAdmin team.

I've just upgraded to v4.9 (from 4.6) and noticed for the first time a dialog requesting a master password. I've gone through the release notes and couldn't find when this feature was implemented.

Anyway, the encryption seems to mess up all saved passwords. When I connect to an pre existing server which had the password saved I get error: Failed to decrypt the saved password. Error: 'utf-8' codec can't decode byte 0x89 in position 3: invalid start byte

After feeding the correct password it connects alright. Sadly it seems I will have to reenter the password for all the servers I manage.

A small nuance is the Save Password checkbox on the Connect Server dialog requiring a lot of clicks for it to turn checked. (running Windows 10 + Chrome)

A more serious issue seems to happen when a connection with SSL tunneling is lost, since I am unable to reconnect to the server as pgAdmin will throw this error on every attempt to reconnect: create_ssh_tunnel() missing 1 required positional argument: 'tunnel_password'

Can't find a way around it other than restarting pgAdmin since the same error appears upon trying to open the server properties. (Edit: I managed to workaround this deadlock by clearing the server password)

Another nuance is that the ssh password can't be saved. This is not the "click lots of times till it kicks in", the save password checkbox is definitely disabled for the ssh password. Haven't found an option to enable it either.

Am I the only one suffering from these issues?

Regards,

Fernando.

El jue., 27 de jun. de 2019 a la(s) 08:05, Akshay Joshi (akshay.joshi@enterprisedb.com) escribió:

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.9.
This release of pgAdmin 4 includes over 27 bug fixes and new features. For more details please see the release notes at:

    https://www.pgadmin.org/docs/pgadmin4/dev/release_notes_4_9.html.

pgAdmin is the leading Open Source graphical management tool for PostgreSQL. For more information, please see:

    https://www.pgadmin.org/

Notable changes in this release include:

• Visually distinguish simple tables from tables that are inherited and from which other tables are inherited.
• Add a framework for testing reversed engineered SQL and CRUD API endpoints.
• Initial support for PostgreSQL 12.
• Ensure we include the CSRF token when uploading files.
• Prevent the geometry viewer grabbing key presses when not in focus under Firefox, IE and Edge.
• Ensure that browser auto-fill doesn't cause Help pages to be opened unexpectedly.
• Fix an initialisation error when two functions with parameters are debugged in parallel.
• Remove additional "SETOF" included when generating CREATE scripts for trigger functions.
• Ensure the correct label is used in panel headers when viewing filtered rows.
• Fix issue where new column should be created with Default value.
• Fix keyboard navigation in "inner" tabsets such as the Query Tool and Debugger.

Builds for Windows and macOS are available now, along with a Python Wheel,
Docker Container and source code tarball from:

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

RPM and DEB packages are expected to be available on the postgresql.org repositories within the next few days.

--

Akshay Joshi

pgAdmin Project