Re: pgAdmin 4 v4.9 released

[Fernando Hevia]

El vie., 28 de jun. de 2019 a la(s) 02:10, Aditya Toshniwal (
aditya.toshni...@enterprisedb.com) escribió:

> Hi,
>
> On Fri, Jun 28, 2019 at 9:42 AM Fernando Hevia  wrote:
>
>> 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.
>>
> Master password was released in 4.7
> https://www.pgadmin.org/docs/pgadmin4/dev/release_notes_4_7.html
>

Ha, I see it now. It is listed as a bug correction and I was looking for a
feature so I missed it.


> 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
>>
> Yes this is an issue. We're trying to figure out the cause. This happens
> only when you upgrade.
>

>> 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)
>>
> This is something we are not facing. Can you please log a bug so that we
> can investigate further -
> https://redmine.postgresql.org/projects/pgadmin4/issues/new
>

Will do. Thanks.


>> 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'
>>
> This is fixed, and will be available in v4.10.
>

Excellent! Looking forward to.


>
>> 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.
>>
> This is disabled by default (ALLOW_SAVE_TUNNEL_PASSWORD = False in
> config.py). You can enable it with ALLOW_SAVE_TUNNEL_PASSWORD = True. Kindly
> refer -
> https://www.pgadmin.org/docs/pgadmin4/dev/desktop_deployment.html?highlight=config#configuration
>

Great. I can save passwords now. :)

Thanks Aditya for the quick response and the continuous effort put into
this great tool!!

Regards,
Fernando.

Re: pgAdmin 4 v4.9 released

[Aditya Toshniwal]

Hi,

On Fri, Jun 28, 2019 at 9:42 AM Fernando Hevia  wrote:

> 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.
>
Master password was released in 4.7
https://www.pgadmin.org/docs/pgadmin4/dev/release_notes_4_7.html

> 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
>
Yes this is an issue. We're trying to figure out the cause. This happens
only when you upgrade.

>
> 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)
>
This is something we are not facing. Can you please log a bug so that we
can investigate further -
https://redmine.postgresql.org/projects/pgadmin4/issues/new

>
> 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'
>
This is fixed, and will be available in v4.10.

>
> 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.
>
This is disabled by default (ALLOW_SAVE_TUNNEL_PASSWORD = False in
config.py). You can enable it with ALLOW_SAVE_TUNNEL_PASSWORD = True. Kindly
refer -
https://www.pgadmin.org/docs/pgadmin4/dev/desktop_deployment.html?highlight=config#configuration

>
> 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.jo...@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
>>
>

-- 
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

Re: import upload file to pgadmin get CSRF error

[Murtuza Zabuawala]

On Fri, Jun 28, 2019 at 10:18 AM Where is Where  wrote:

> Thanks for the clarification Murtuza.  Any idea about when it might be, eg
> the packages in here:
> https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7Server-x86_64/
> . Thanks!
>

Not sure, that is something handled by Postgres packaging community and not
by pgAdmin4 team.

-- Murtuza



>
> On Fri, Jun 28, 2019 at 1:55 PM Murtuza Zabuawala <
> murtuza.zabuaw...@enterprisedb.com> wrote:
>
>> On Fri, Jun 28, 2019 at 6:31 AM Where is Where  wrote:
>>
>>> Is there a way to apply this bug fix on a installation on redhat?The 4.9
>>> redhat yum package is not available yet. Thanks!
>>>
>>
>> No, Release version of JS files are bundled by webpacker, so it is not
>> feasible to patch them.
>> You have to wait until the yum repo gets the updated version.
>>
>>
>> -- Murtuza
>>
>>>
>>> On Tue, Jun 25, 2019 at 9:30 AM Where is Where 
>>> wrote:
>>>
 Thank you! I will wait for the release on Thursday. Will the redhat yum
 package be updated too? Or can I download the tar file and use some file
 from it to replace the file on the server?

 Thanks.

 On Mon, Jun 24, 2019 at 4:25 PM Khushboo Vashi <
 khushboo.va...@enterprisedb.com> wrote:

>
>
> On Mon, Jun 24, 2019 at 11:42 AM Where is Where 
> wrote:
>
>> Thank you! I just saw that too. I tried to apply that diff only:
>> https://redmine.postgresql.org/projects/pgadmin4/repository/revisions/08b78fb6a11283731cdf59d2a29fdc75e459582e/diff/web/pgadmin/misc/file_manager/static/js/utility.js
>> But it doesn't seem to fix the problem.
>>
>> It will require bundling of the static files after applying the patch.
> Instead, you can install the pgAdmin from the nightly builds having
> the latest code.
> https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2019-06-24/
>
> *  // We need to append our csrf token with dropzone's ajax 
> request header
>> *
>>
>> *  let csrfToken = {};
>> *
>>
>> *  csrfToken[pgAdmin.csrf_token_header] = pgAdmin.csrf_token;
>> *
>>
>>
>>   $('div#multiple-uploads').dropzone({
>>
>> paramName: 'newfile',
>>
>> url: pgAdmin.FileUtils.fileConnector,
>>
>> *headers: csrfToken,*
>>
>>
>> Thanks, Junran
>>
>> On Mon, Jun 24, 2019 at 3:47 PM Khushboo Vashi <
>> khushboo.va...@enterprisedb.com> wrote:
>>
>>>
>>> On Mon, Jun 24, 2019 at 11:13 AM Where is Where 
>>> wrote:
>>>
 Hello, we are trying to import csv file to database from pgadmin,
 but when uploading file it reports '
 400 Bad Request Bad Request The CSRF token is
 missing. '
 I looked at config.py but can't find any related setting.
 Any idea is much appreciated.

 This issue has already been reported and fixed. (Ref:
>>> https://redmine.postgresql.org/issues/4350)
>>> You will get the fix in the upcoming release which is scheduled on
>>> coming Thursday.
>>>
>>> Thanks,
>>> Khushboo
>>>
>>

Re: import upload file to pgadmin get CSRF error

[Where is Where]

Thanks for the clarification Murtuza.  Any idea about when it might be, eg
the packages in here:
https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7Server-x86_64/
. Thanks!

On Fri, Jun 28, 2019 at 1:55 PM Murtuza Zabuawala <
murtuza.zabuaw...@enterprisedb.com> wrote:

> On Fri, Jun 28, 2019 at 6:31 AM Where is Where  wrote:
>
>> Is there a way to apply this bug fix on a installation on redhat?The 4.9
>> redhat yum package is not available yet. Thanks!
>>
>
> No, Release version of JS files are bundled by webpacker, so it is not
> feasible to patch them.
> You have to wait until the yum repo gets the updated version.
>
>
> -- Murtuza
>
>>
>> On Tue, Jun 25, 2019 at 9:30 AM Where is Where  wrote:
>>
>>> Thank you! I will wait for the release on Thursday. Will the redhat yum
>>> package be updated too? Or can I download the tar file and use some file
>>> from it to replace the file on the server?
>>>
>>> Thanks.
>>>
>>> On Mon, Jun 24, 2019 at 4:25 PM Khushboo Vashi <
>>> khushboo.va...@enterprisedb.com> wrote:
>>>


 On Mon, Jun 24, 2019 at 11:42 AM Where is Where 
 wrote:

> Thank you! I just saw that too. I tried to apply that diff only:
> https://redmine.postgresql.org/projects/pgadmin4/repository/revisions/08b78fb6a11283731cdf59d2a29fdc75e459582e/diff/web/pgadmin/misc/file_manager/static/js/utility.js
> But it doesn't seem to fix the problem.
>
> It will require bundling of the static files after applying the patch.
 Instead, you can install the pgAdmin from the nightly builds having the
 latest code.
 https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2019-06-24/

 *  // We need to append our csrf token with dropzone's ajax 
 request header
> *
>
> *  let csrfToken = {};
> *
>
> *  csrfToken[pgAdmin.csrf_token_header] = pgAdmin.csrf_token;
> *
>
>
>   $('div#multiple-uploads').dropzone({
>
> paramName: 'newfile',
>
> url: pgAdmin.FileUtils.fileConnector,
>
> *headers: csrfToken,*
>
>
> Thanks, Junran
>
> On Mon, Jun 24, 2019 at 3:47 PM Khushboo Vashi <
> khushboo.va...@enterprisedb.com> wrote:
>
>>
>> On Mon, Jun 24, 2019 at 11:13 AM Where is Where 
>> wrote:
>>
>>> Hello, we are trying to import csv file to database from pgadmin,
>>> but when uploading file it reports '
>>> 400 Bad Request Bad Request The CSRF token is
>>> missing. '
>>> I looked at config.py but can't find any related setting.
>>> Any idea is much appreciated.
>>>
>>> This issue has already been reported and fixed. (Ref:
>> https://redmine.postgresql.org/issues/4350)
>> You will get the fix in the upcoming release which is scheduled on
>> coming Thursday.
>>
>> Thanks,
>> Khushboo
>>
>

Re: pgAdmin 4 v4.9 released

[Fernando Hevia]

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.jo...@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
>

Re: import upload file to pgadmin get CSRF error

[Murtuza Zabuawala]

On Fri, Jun 28, 2019 at 6:31 AM Where is Where  wrote:

> Is there a way to apply this bug fix on a installation on redhat?The 4.9
> redhat yum package is not available yet. Thanks!
>

No, Release version of JS files are bundled by webpacker, so it is not
feasible to patch them.
You have to wait until the yum repo gets the updated version.


-- Murtuza

>
> On Tue, Jun 25, 2019 at 9:30 AM Where is Where  wrote:
>
>> Thank you! I will wait for the release on Thursday. Will the redhat yum
>> package be updated too? Or can I download the tar file and use some file
>> from it to replace the file on the server?
>>
>> Thanks.
>>
>> On Mon, Jun 24, 2019 at 4:25 PM Khushboo Vashi <
>> khushboo.va...@enterprisedb.com> wrote:
>>
>>>
>>>
>>> On Mon, Jun 24, 2019 at 11:42 AM Where is Where 
>>> wrote:
>>>
 Thank you! I just saw that too. I tried to apply that diff only:
 https://redmine.postgresql.org/projects/pgadmin4/repository/revisions/08b78fb6a11283731cdf59d2a29fdc75e459582e/diff/web/pgadmin/misc/file_manager/static/js/utility.js
 But it doesn't seem to fix the problem.

 It will require bundling of the static files after applying the patch.
>>> Instead, you can install the pgAdmin from the nightly builds having the
>>> latest code.
>>> https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2019-06-24/
>>>
>>> *  // We need to append our csrf token with dropzone's ajax request 
>>> header
 *

 *  let csrfToken = {};
 *

 *  csrfToken[pgAdmin.csrf_token_header] = pgAdmin.csrf_token;
 *


   $('div#multiple-uploads').dropzone({

 paramName: 'newfile',

 url: pgAdmin.FileUtils.fileConnector,

 *headers: csrfToken,*


 Thanks, Junran

 On Mon, Jun 24, 2019 at 3:47 PM Khushboo Vashi <
 khushboo.va...@enterprisedb.com> wrote:

>
> On Mon, Jun 24, 2019 at 11:13 AM Where is Where 
> wrote:
>
>> Hello, we are trying to import csv file to database from pgadmin, but
>> when uploading file it reports '
>> 400 Bad Request Bad Request The CSRF token is
>> missing. '
>> I looked at config.py but can't find any related setting.
>> Any idea is much appreciated.
>>
>> This issue has already been reported and fixed. (Ref:
> https://redmine.postgresql.org/issues/4350)
> You will get the fix in the upcoming release which is scheduled on
> coming Thursday.
>
> Thanks,
> Khushboo
>

Re: import upload file to pgadmin get CSRF error

[Where is Where]

Is there a way to apply this bug fix on a installation on redhat?The 4.9
redhat yum package is not available yet. Thanks!

On Tue, Jun 25, 2019 at 9:30 AM Where is Where  wrote:

> Thank you! I will wait for the release on Thursday. Will the redhat yum
> package be updated too? Or can I download the tar file and use some file
> from it to replace the file on the server?
>
> Thanks.
>
> On Mon, Jun 24, 2019 at 4:25 PM Khushboo Vashi <
> khushboo.va...@enterprisedb.com> wrote:
>
>>
>>
>> On Mon, Jun 24, 2019 at 11:42 AM Where is Where 
>> wrote:
>>
>>> Thank you! I just saw that too. I tried to apply that diff only:
>>> https://redmine.postgresql.org/projects/pgadmin4/repository/revisions/08b78fb6a11283731cdf59d2a29fdc75e459582e/diff/web/pgadmin/misc/file_manager/static/js/utility.js
>>> But it doesn't seem to fix the problem.
>>>
>>> It will require bundling of the static files after applying the patch.
>> Instead, you can install the pgAdmin from the nightly builds having the
>> latest code.
>> https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2019-06-24/
>>
>> *  // We need to append our csrf token with dropzone's ajax request 
>> header
>>> *
>>>
>>> *  let csrfToken = {};
>>> *
>>>
>>> *  csrfToken[pgAdmin.csrf_token_header] = pgAdmin.csrf_token;
>>> *
>>>
>>>
>>>   $('div#multiple-uploads').dropzone({
>>>
>>> paramName: 'newfile',
>>>
>>> url: pgAdmin.FileUtils.fileConnector,
>>>
>>> *headers: csrfToken,*
>>>
>>>
>>> Thanks, Junran
>>>
>>> On Mon, Jun 24, 2019 at 3:47 PM Khushboo Vashi <
>>> khushboo.va...@enterprisedb.com> wrote:
>>>

 On Mon, Jun 24, 2019 at 11:13 AM Where is Where 
 wrote:

> Hello, we are trying to import csv file to database from pgadmin, but
> when uploading file it reports '
> 400 Bad Request Bad Request The CSRF token is missing.
> '
> I looked at config.py but can't find any related setting.
> Any idea is much appreciated.
>
> This issue has already been reported and fixed. (Ref:
 https://redmine.postgresql.org/issues/4350)
 You will get the fix in the upcoming release which is scheduled on
 coming Thursday.

 Thanks,
 Khushboo

>>>

Re: pgadmin 4 feature behavior change requests

[Cherio]

>
> 2. Have a sql query check button (unless I'm mistaken, I don't see it)
> where it will check if your sql syntax is correct, but wont execute it.
>

I personally use "Analyze" for that purpose. It seems to be doing exactly
that

Re: pgadmin 4 feature behavior change requests

[Alex Williams]

Thanks, will do!

Also, one very nice feature would be (will post it on redmine) to PLEASE 
seperate internal functions from user defined functions. I know we can prefix 
it like with an underbar like _some_sp_function, but our company uses 
sp_some_function, and have to wait for the entire list to load and scroll alot 
(and sometimes the scroll gets corrupted where the display is shown multiple 
times and appears blurry)

Sent with [ProtonMail](https://protonmail.com) Secure Email.

‐‐‐ Original Message ‐‐‐
On Wednesday, June 26, 2019 11:57 PM, Khushboo Vashi 
 wrote:

> Hi Alex,
>
> On Wed, Jun 26, 2019 at 10:39 PM Alex Williams  
> wrote:
>
>> Hi,
>>
>> 1. Get rid of the div overlay on query execution.
>> There have been many times when I'm running a query and either the 
>> connection is broken and it takes more than a few minutes for the app to 
>> detect that and stop, and most times, the Stop button does not work and I 
>> need to rerun the query again, but have to wait until the div overlay goes 
>> away...my "trick" is to save the query which sometimes works where the app 
>> gives the broken connection message, but sometimes it doesn't work -- what 
>> would be helpful if that there was no div overlay so I can copy/paste the 
>> query into a new session/tab. Can you just disable the execute query button 
>> and have status bar somewhere stating the query is running without the 
>> overlay? It makes for a pretty design, but in real life / workflow wise, 
>> it's not good.
>>
>> 2. Have a sql query check button (unless I'm mistaken, I don't see it) where 
>> it will check if your sql syntax is correct, but wont execute it.
>
> You can create the feature request @ 
> https://redmine.postgresql.org/projects/pgadmin4
>
>> 3. At least on CentOS pgadmin 4.8, if I right click my query to copy it, 
>> instead of the copy option, I just get panel options. Can we please have 
>> copy/cut there too?
>
> This one is already logged.
>
>> 4. When right clicking a table and choosing View/Edit data/select top 100 
>> from it, does the query need to be read only / greyed out? Why not be able 
>> to do it for convenience and then have the ability to change the query?
>
> pgAdmin 4 has 2 ways for querying the data, one is Query Tool where you can 
> write your own query and view the data and another is View Data through which 
> you can view/filter/modify the data without writing SQL query. Currently, the 
> implementation of the automatic mode detection of the Query Tool is in 
> progress, you can get the idea about it from the pgadmin-hackers group where 
> it is being discussed and the WIP patch is available.
>
>> Thanks!
>>
>> Alex
>
> Thanks,
> Khushboo
>
>> Sent with [ProtonMail](https://protonmail.com) Secure Email.

PgAdmin4 behind SSL proxy

[Andrew Coleman]

Has anyone had any success running PgAdmin4 behind a reverse proxy? I am using 
Traefik for routing in my Kubernetes cluster and I am experiencing some strange 
behavior.

With SSL:

POST /login, cookie is returned with an empty value, GET /browser redirect to 
/login
Sometimes even requests to /user_management/current_user.js actually returns 
index.html and causes undefined behavior on the page.

Without SSL, with kubectl port-forward:

POST /login, cookie is returned with a value, GET to /browser returns page 
contents as expected.

I have set X-Forwarded-Proto to https, but that doesn’t do anything. I have set 
X-Scheme to https and that helps, but it’s not all the way. Cookies returned do 
not have the Secure; flag (not sure if that’s necessary, though). I have tried 
setting the values in this blog post both in config.py and in the environment 
to no success:

https://blog.miguelgrinberg.com/post/cookie-security-for-flask-applications

I really need to expose PgAdmin via https and not http. Is there any way to do 
this without so much hate and discontent?

Thanks,
Andrew

Re: PgAdmin 4.9, no release notes

[wambacher]

Am 27.06.19 um 16:08 schrieb Cherio:
> Hello,
>
> I just received a notification that 4.9 version was released however I
> could find no corresponding release notes
> here: https://www.pgadmin.org/docs/pgadmin4/4.x/release_notes.html
>
> Thanks

No problem: i can see and read it.

walter

-- 
My projects:

Admin Boundaries of the World 
Missing Boundaries

Emergency Map 
Postal Code Map (Germany only) 
Fools (QA for zipcodes in Germany) 
Postcode Boundaries of Germany 

Re: How to close pgAdmin4

[George Weaver]

Hi Michel,

Thanks!

(One more inconvenient thing about pgAdmin4.)

George

On 27/06/2019 8:53 a.m., Michel Feinstein wrote:
Look for it in the system tray bar, at the lower right corner of the 
screen, right click it and see the option to exit.


On Thu, Jun 27, 2019, 10:42 George Weaver > wrote:


Good morning,

I would like to know how to "really" close pgAdmin4.

When I close the pgAdmin4 tab or the browser supporting pgAdmin4
(Firefox 67.0.4), this does not close pgAdmin4.  It still resides in
Task Manager (Windows 10).

This is very inconvenient.  If after closing pgAdmin4 I try and
delete a
database via other means (eg psql) I get the following error message:

 DROP DATABASE IF EXISTS development;

 ERROR:  database "development" is being accessed by other users
 DETAIL:  There are 2 other sessions using the database.

This forces me to start Task Manager, scroll down to pgAdmin4 and
select
End Task.

How do I close pgAdmin4 so it is no longer running on the computer
and I
can avoid these nuisance steps.

Thanks,

George





--
Cleartag Software, Inc.
972 McMillan Avenue
Winnipeg, MB
R3M 0V7
(204) 284-9839 phone/cell
(204) 284-9838 fax
gwea...@cleartagsoftware.com

Fast. Accurate. Easy.

Re: How to close pgAdmin4

[Michel Feinstein]

My pleasure, I am not a big fan of this either... But many applications
have this behavior, so I am kinda used to it.

On Thu, Jun 27, 2019, 11:34 George Weaver 
wrote:

> Hi Michel,
>
> Thanks!
>
> (One more inconvenient thing about pgAdmin4.)
>
> George
> On 27/06/2019 8:53 a.m., Michel Feinstein wrote:
>
> Look for it in the system tray bar, at the lower right corner of the
> screen, right click it and see the option to exit.
>
> On Thu, Jun 27, 2019, 10:42 George Weaver  wrote:
>
>> Good morning,
>>
>> I would like to know how to "really" close pgAdmin4.
>>
>> When I close the pgAdmin4 tab or the browser supporting pgAdmin4
>> (Firefox 67.0.4), this does not close pgAdmin4.  It still resides in
>> Task Manager (Windows 10).
>>
>> This is very inconvenient.  If after closing pgAdmin4 I try and delete a
>> database via other means (eg psql) I get the following error message:
>>
>>  DROP DATABASE IF EXISTS development;
>>
>>  ERROR:  database "development" is being accessed by other users
>>  DETAIL:  There are 2 other sessions using the database.
>>
>> This forces me to start Task Manager, scroll down to pgAdmin4 and select
>> End Task.
>>
>> How do I close pgAdmin4 so it is no longer running on the computer and I
>> can avoid these nuisance steps.
>>
>> Thanks,
>>
>> George
>>
>>
>>
>>
>> --
> Cleartag Software, Inc.
> 972 McMillan Avenue
> Winnipeg, MB
> R3M 0V7
> (204) 284-9839 phone/cell
> (204) 284-9838 faxgwea...@cleartagsoftware.com
>
> Fast. Accurate. Easy.
>
>

Re: PgAdmin 4.9, no release notes

[Dave Page]

Hi

The website should update automatically in the next hour or so.

On Thu, Jun 27, 2019 at 10:08 AM Cherio  wrote:

> Hello,
>
> I just received a notification that 4.9 version was released however I
> could find no corresponding release notes here:
> https://www.pgadmin.org/docs/pgadmin4/4.x/release_notes.html
>
> Thanks
>


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

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

Re: [EXTERNAL] - Re: How to close pgAdmin4

[Michel Feinstein]

Correct.

pgAdmin runs as a webserver in the background, closing the Browser Tab or
Window doesn't kill the webserver itself, just the web session with the
server.

On Thu, Jun 27, 2019 at 11:13 AM Michelle Schwan 
wrote:

> OK – so no close button on the actual window itself.
>
>
>
> *From:* Michel Feinstein 
> *Sent:* Thursday, June 27, 2019 10:11 AM
> *To:* Michelle Schwan 
> *Cc:* richard coleman ; George Weaver <
> gwea...@shaw.ca>; pgAdmin Support 
> *Subject:* Re: [EXTERNAL] - Re: How to close pgAdmin4
>
>
>
> Google "windows system tray".
>
>
>
> On Thu, Jun 27, 2019 at 11:09 AM Michelle Schwan 
> wrote:
>
> I do not see that icon at all in pgAdmin.  Where is that ?
>
>
>
>
>
> *From:* richard coleman 
> *Sent:* Thursday, June 27, 2019 10:07 AM
> *To:* Michelle Schwan 
> *Cc:* Michel Feinstein ; George Weaver <
> gwea...@shaw.ca>; pgAdmin Support 
> *Subject:* Re: [EXTERNAL] - Re: How to close pgAdmin4
>
>
>
> Michelle,
>
>
>
> Right click the little picture of the elephant, the context menu should
> include an entry "Shut down server", select that and you will *correctly* shut
> down pgAdmin4.
>
>
>
> [image: context_menu_pgAdmin4_taskbar.png]
>
>
>
> Some of your confusion probably stems from the fact, that contrary to
> appearances, pgAdmin4 is still *not* a *desktop application*.  It would
> *really* be nice if we could get an actual desktop application, like
> pgAdmin3 was, as opposed to the lobotomized web server that pgAdmin4 is.
>
>
>
> ¯\_(ツ)_/¯
>
>
>
> rik.
>
>
>
> On Thu, Jun 27, 2019 at 9:59 AM Michelle Schwan 
> wrote:
>
> Could you show a screen shot of that?  I cannot find the option to exit.
>
>
>
> *From:* Michel Feinstein 
> *Sent:* Thursday, June 27, 2019 9:54 AM
> *To:* George Weaver 
> *Cc:* pgAdmin Support 
> *Subject:* [EXTERNAL] - Re: How to close pgAdmin4
>
>
>
> Look for it in the system tray bar, at the lower right corner of the
> screen, right click it and see the option to exit.
>
>
>
> On Thu, Jun 27, 2019, 10:42 George Weaver  wrote:
>
> Good morning,
>
> I would like to know how to "really" close pgAdmin4.
>
> When I close the pgAdmin4 tab or the browser supporting pgAdmin4
> (Firefox 67.0.4), this does not close pgAdmin4.  It still resides in
> Task Manager (Windows 10).
>
> This is very inconvenient.  If after closing pgAdmin4 I try and delete a
> database via other means (eg psql) I get the following error message:
>
>  DROP DATABASE IF EXISTS development;
>
>  ERROR:  database "development" is being accessed by other users
>  DETAIL:  There are 2 other sessions using the database.
>
> This forces me to start Task Manager, scroll down to pgAdmin4 and select
> End Task.
>
> How do I close pgAdmin4 so it is no longer running on the computer and I
> can avoid these nuisance steps.
>
> Thanks,
>
> George
>
>

RE: [EXTERNAL] - Re: How to close pgAdmin4

[Michelle Schwan]

OK – so no close button on the actual window itself.

From: Michel Feinstein 
Sent: Thursday, June 27, 2019 10:11 AM
To: Michelle Schwan 
Cc: richard coleman ; George Weaver 
; pgAdmin Support 
Subject: Re: [EXTERNAL] - Re: How to close pgAdmin4

Google "windows system tray".

On Thu, Jun 27, 2019 at 11:09 AM Michelle Schwan 
mailto:msch...@opentext.com>> wrote:
I do not see that icon at all in pgAdmin.  Where is that ?

[cid:image001.jpg@01D52CD1.0781ED00]

From: richard coleman 
mailto:rcoleman.ascen...@gmail.com>>
Sent: Thursday, June 27, 2019 10:07 AM
To: Michelle Schwan mailto:msch...@opentext.com>>
Cc: Michel Feinstein 
mailto:michelfeinst...@gmail.com>>; George Weaver 
mailto:gwea...@shaw.ca>>; pgAdmin Support 
mailto:pgadmin-supp...@postgresql.org>>
Subject: Re: [EXTERNAL] - Re: How to close pgAdmin4

Michelle,

Right click the little picture of the elephant, the context menu should include 
an entry "Shut down server", select that and you will correctly shut down 
pgAdmin4.

[context_menu_pgAdmin4_taskbar.png]

Some of your confusion probably stems from the fact, that contrary to 
appearances, pgAdmin4 is still not a desktop application.  It would really be 
nice if we could get an actual desktop application, like pgAdmin3 was, as 
opposed to the lobotomized web server that pgAdmin4 is.

¯\_(ツ)_/¯

rik.

On Thu, Jun 27, 2019 at 9:59 AM Michelle Schwan 
mailto:msch...@opentext.com>> wrote:
Could you show a screen shot of that?  I cannot find the option to exit.

From: Michel Feinstein 
mailto:michelfeinst...@gmail.com>>
Sent: Thursday, June 27, 2019 9:54 AM
To: George Weaver mailto:gwea...@shaw.ca>>
Cc: pgAdmin Support 
mailto:pgadmin-supp...@postgresql.org>>
Subject: [EXTERNAL] - Re: How to close pgAdmin4

Look for it in the system tray bar, at the lower right corner of the screen, 
right click it and see the option to exit.

On Thu, Jun 27, 2019, 10:42 George Weaver 
mailto:gwea...@shaw.ca>> wrote:
Good morning,

I would like to know how to "really" close pgAdmin4.

When I close the pgAdmin4 tab or the browser supporting pgAdmin4
(Firefox 67.0.4), this does not close pgAdmin4.  It still resides in
Task Manager (Windows 10).

This is very inconvenient.  If after closing pgAdmin4 I try and delete a
database via other means (eg psql) I get the following error message:

 DROP DATABASE IF EXISTS development;

 ERROR:  database "development" is being accessed by other users
 DETAIL:  There are 2 other sessions using the database.

This forces me to start Task Manager, scroll down to pgAdmin4 and select
End Task.

How do I close pgAdmin4 so it is no longer running on the computer and I
can avoid these nuisance steps.

Thanks,

George

Re: [EXTERNAL] - Re: How to close pgAdmin4

[richard coleman]

Michelle,

Right click the little picture of the elephant, the context menu should
include an entry "Shut down server", select that and you will *correctly* shut
down pgAdmin4.

[image: context_menu_pgAdmin4_taskbar.png]

Some of your confusion probably stems from the fact, that contrary to
appearances, pgAdmin4 is still *not* a *desktop application*.  It would
*really* be nice if we could get an actual desktop application, like
pgAdmin3 was, as opposed to the lobotomized web server that pgAdmin4 is.

¯\_(ツ)_/¯

rik.

On Thu, Jun 27, 2019 at 9:59 AM Michelle Schwan 
wrote:

> Could you show a screen shot of that?  I cannot find the option to exit.
>
>
>
> *From:* Michel Feinstein 
> *Sent:* Thursday, June 27, 2019 9:54 AM
> *To:* George Weaver 
> *Cc:* pgAdmin Support 
> *Subject:* [EXTERNAL] - Re: How to close pgAdmin4
>
>
>
> Look for it in the system tray bar, at the lower right corner of the
> screen, right click it and see the option to exit.
>
>
>
> On Thu, Jun 27, 2019, 10:42 George Weaver  wrote:
>
> Good morning,
>
> I would like to know how to "really" close pgAdmin4.
>
> When I close the pgAdmin4 tab or the browser supporting pgAdmin4
> (Firefox 67.0.4), this does not close pgAdmin4.  It still resides in
> Task Manager (Windows 10).
>
> This is very inconvenient.  If after closing pgAdmin4 I try and delete a
> database via other means (eg psql) I get the following error message:
>
>  DROP DATABASE IF EXISTS development;
>
>  ERROR:  database "development" is being accessed by other users
>  DETAIL:  There are 2 other sessions using the database.
>
> This forces me to start Task Manager, scroll down to pgAdmin4 and select
> End Task.
>
> How do I close pgAdmin4 so it is no longer running on the computer and I
> can avoid these nuisance steps.
>
> Thanks,
>
> George
>
>
>
>

Re: [EXTERNAL] - Re: How to close pgAdmin4

[Michel Feinstein]

[image: image.png]

The last one at the bottom, I am still at pgAdmin 4.6 though.

On Thu, Jun 27, 2019 at 10:58 AM Michelle Schwan 
wrote:

> Could you show a screen shot of that?  I cannot find the option to exit.
>
>
>
> *From:* Michel Feinstein 
> *Sent:* Thursday, June 27, 2019 9:54 AM
> *To:* George Weaver 
> *Cc:* pgAdmin Support 
> *Subject:* [EXTERNAL] - Re: How to close pgAdmin4
>
>
>
> Look for it in the system tray bar, at the lower right corner of the
> screen, right click it and see the option to exit.
>
>
>
> On Thu, Jun 27, 2019, 10:42 George Weaver  wrote:
>
> Good morning,
>
> I would like to know how to "really" close pgAdmin4.
>
> When I close the pgAdmin4 tab or the browser supporting pgAdmin4
> (Firefox 67.0.4), this does not close pgAdmin4.  It still resides in
> Task Manager (Windows 10).
>
> This is very inconvenient.  If after closing pgAdmin4 I try and delete a
> database via other means (eg psql) I get the following error message:
>
>  DROP DATABASE IF EXISTS development;
>
>  ERROR:  database "development" is being accessed by other users
>  DETAIL:  There are 2 other sessions using the database.
>
> This forces me to start Task Manager, scroll down to pgAdmin4 and select
> End Task.
>
> How do I close pgAdmin4 so it is no longer running on the computer and I
> can avoid these nuisance steps.
>
> Thanks,
>
> George
>
>
>
>

RE: [EXTERNAL] - Re: How to close pgAdmin4

[Michelle Schwan]

Could you show a screen shot of that?  I cannot find the option to exit.

From: Michel Feinstein 
Sent: Thursday, June 27, 2019 9:54 AM
To: George Weaver 
Cc: pgAdmin Support 
Subject: [EXTERNAL] - Re: How to close pgAdmin4

Look for it in the system tray bar, at the lower right corner of the screen, 
right click it and see the option to exit.

On Thu, Jun 27, 2019, 10:42 George Weaver 
mailto:gwea...@shaw.ca>> wrote:
Good morning,

I would like to know how to "really" close pgAdmin4.

When I close the pgAdmin4 tab or the browser supporting pgAdmin4
(Firefox 67.0.4), this does not close pgAdmin4.  It still resides in
Task Manager (Windows 10).

This is very inconvenient.  If after closing pgAdmin4 I try and delete a
database via other means (eg psql) I get the following error message:

 DROP DATABASE IF EXISTS development;

 ERROR:  database "development" is being accessed by other users
 DETAIL:  There are 2 other sessions using the database.

This forces me to start Task Manager, scroll down to pgAdmin4 and select
End Task.

How do I close pgAdmin4 so it is no longer running on the computer and I
can avoid these nuisance steps.

Thanks,

George

Re: How to close pgAdmin4

[Michel Feinstein]

Look for it in the system tray bar, at the lower right corner of the
screen, right click it and see the option to exit.

On Thu, Jun 27, 2019, 10:42 George Weaver  wrote:

> Good morning,
>
> I would like to know how to "really" close pgAdmin4.
>
> When I close the pgAdmin4 tab or the browser supporting pgAdmin4
> (Firefox 67.0.4), this does not close pgAdmin4.  It still resides in
> Task Manager (Windows 10).
>
> This is very inconvenient.  If after closing pgAdmin4 I try and delete a
> database via other means (eg psql) I get the following error message:
>
>  DROP DATABASE IF EXISTS development;
>
>  ERROR:  database "development" is being accessed by other users
>  DETAIL:  There are 2 other sessions using the database.
>
> This forces me to start Task Manager, scroll down to pgAdmin4 and select
> End Task.
>
> How do I close pgAdmin4 so it is no longer running on the computer and I
> can avoid these nuisance steps.
>
> Thanks,
>
> George
>
>
>
>
>

How to close pgAdmin4

[George Weaver]

Good morning,

I would like to know how to "really" close pgAdmin4.

When I close the pgAdmin4 tab or the browser supporting pgAdmin4 
(Firefox 67.0.4), this does not close pgAdmin4.  It still resides in 
Task Manager (Windows 10).


This is very inconvenient.  If after closing pgAdmin4 I try and delete a 
database via other means (eg psql) I get the following error message:


    DROP DATABASE IF EXISTS development;

    ERROR:  database "development" is being accessed by other users
    DETAIL:  There are 2 other sessions using the database.

This forces me to start Task Manager, scroll down to pgAdmin4 and select 
End Task.


How do I close pgAdmin4 so it is no longer running on the computer and I 
can avoid these nuisance steps.


Thanks,

George

pgAdmin 4 v4.9 released

[Akshay Joshi]

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