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

[Michelle Schwan]

I do not see that icon at all in pgAdmin.  Where is that ?

[cid:image001.jpg@01D52CD0.6D25C830]

From: richard coleman 
Sent: Thursday, June 27, 2019 10:07 AM
To: Michelle Schwan 
Cc: Michel Feinstein ; George Weaver 
; 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.

[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

[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: [EXTERNAL] - Re: pgAdmin4 4.8 Kubuntu issues

[Michelle Schwan]

It’s not just on Kubuntu – it also occurs on Windows as well.

There should be a user-friendly way to turn that off.

pgAdmin III seems a lot better for functionality and usability.


From: richard coleman 
Sent: Wednesday, June 05, 2019 8:17 AM
To: Cherio 
Cc: pgAdmin Support 
Subject: [EXTERNAL] - Re: pgAdmin4 4.8 Kubuntu issues

Cherio,

I am sorry to inform you, but there is no mention of "config_local.py" on that 
page, nor any indication of where I would find it.

rik.

On Tue, Jun 4, 2019 at 5:06 PM Cherio 
mailto:che...@gmail.com>> wrote:
Put "MASTER_PASSWORD_REQUIRED = False" line into your 
"lib/python?.?/site-packages/pgadmin4/config_local.py". This is in the docs: 
https://www.pgadmin.org/docs/pgadmin4/dev/master_password.html

On Tue, Jun 4, 2019 at 4:41 PM richard coleman 
mailto:rcoleman.ascen...@gmail.com>> wrote:
To whomever,

Running a newly update pgAdmin 4 version 4.8 on my Kubuntu box.  There are a 
couple of glaring issues.

First: It keeps prompting to; "Set Master Password"
I don't want to set another password that I'll just end up forgetting.

Second: When I click the "?" button on that dialog box it takes me to this page:
"http://127.0.0.1:33681/help/help/master_password.html";
Which returns "404 Not Found"

Hopefully there is a simple solution to these issues.

Thanks,

rik.

RE: [EXTERNAL] - Re: pgAdmin IV

[Michelle Schwan]

Aditya,

That is not very intuitive!  Why can’t the information be displayed?  All of 
the other database tools for other databases allow this.

Thanks,
Michelle

From: Aditya Toshniwal 
Sent: Tuesday, June 04, 2019 10:50 AM
To: Michelle Schwan 
Cc: pgadmin-support lists.postgresql.org 
Subject: [EXTERNAL] - Re: pgAdmin IV

You need to double click on the "[" cell. It is a json data.


Thanks,
Aditya Toshniwal


On Tue, Jun 4, 2019, 20:10 Michelle Schwan 
mailto:msch...@opentext.com>> wrote:
This is in all versions of pgAdmin IV.

When generating an explain plan for a query, the data output only returns “[“.  
In pgAdmin III, there was a detailed output.
It is easier to read the detailed data output than the explain pictures – I 
have to keep my mouse on the picture to read it, very inconvenient.
[cid:image003.png@01D51AC1.4F95B800]

Same query in pgAdmin III
[cid:image002.png@01D51AC1.D939C5B0]

Thanks,
Michelle Schwan
Database Architect
msch...@opentext.com<mailto:msch...@opentext.com>
Phone: (519) 888 7111 ext 3241
Website:
www.opentext.com<http://www.opentext.com/>

[http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]<http://www.opentext.com/2/email-signature-logo>

This email message is confidential, may be privileged, and is intended for the 
exclusive use of the addressee. Any other person is strictly prohibited from 
disclosing or reproducing it. If the addressee cannot be reached or is unknown 
to you, please inform the sender by return email and delete this email message 
and all copies immediately.

pgAdmin IV

[Michelle Schwan]

This is in all versions of pgAdmin IV.

When generating an explain plan for a query, the data output only returns "[".  
In pgAdmin III, there was a detailed output.
It is easier to read the detailed data output than the explain pictures - I 
have to keep my mouse on the picture to read it, very inconvenient.
[cid:image003.png@01D51AC1.4F95B800]

Same query in pgAdmin III
[cid:image002.png@01D51AC1.D939C5B0]

Thanks,
Michelle Schwan
Database Architect
msch...@opentext.com<mailto:msch...@opentext.com>
Phone: (519) 888 7111 ext 3241
Website:
www.opentext.com<http://www.opentext.com/>

[http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]<http://www.opentext.com/2/email-signature-logo>

This email message is confidential, may be privileged, and is intended for the 
exclusive use of the addressee. Any other person is strictly prohibited from 
disclosing or reproducing it. If the addressee cannot be reached or is unknown 
to you, please inform the sender by return email and delete this email message 
and all copies immediately.

pgAdmin IV

[Michelle Schwan]

>From version pgAdmin IV 4.6 and up, I am now receiving the following error 
>message when I import a database into PostgreSQL.
[cid:image001.png@01D51AC0.3A964FB0]

The database loads fine, but the error that public already exists seems 
strange.  Public is the default schema when creating a database - should the 
message just give a warning instead of an error?
Having a Failed (exit code: 1) error makes it seem like the file did not load - 
when in fact it did.
This should be handled better.

Thanks,
Michelle Schwan
Database Architect
msch...@opentext.com<mailto:msch...@opentext.com>
Phone: (519) 888 7111 ext 3241
Website:
www.opentext.com<http://www.opentext.com/>

[http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]<http://www.opentext.com/2/email-signature-logo>

This email message is confidential, may be privileged, and is intended for the 
exclusive use of the addressee. Any other person is strictly prohibited from 
disclosing or reproducing it. If the addressee cannot be reached or is unknown 
to you, please inform the sender by return email and delete this email message 
and all copies immediately.

pgAdmin IV

[Michelle Schwan]

In versions 4.7 and 4.8 I am getting an error when trying to import a csv file 
into a table.

The CSV file loads in pgAdmin III with no issues.

The file size is 4,557,820 KB (only 5 columns in the table and 2 indexes).  
Smaller files load with no issues.

[cid:image002.jpg@01D51ABE.814440E0]

Thanks,
Michelle Schwan
Database Architect
msch...@opentext.com<mailto:msch...@opentext.com>
Phone: (519) 888 7111 ext 3241
Website:
www.opentext.com<http://www.opentext.com/>

[http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]<http://www.opentext.com/2/email-signature-logo>

This email message is confidential, may be privileged, and is intended for the 
exclusive use of the addressee. Any other person is strictly prohibited from 
disclosing or reproducing it. If the addressee cannot be reached or is unknown 
to you, please inform the sender by return email and delete this email message 
and all copies immediately.

pgAdmin v4.7

[Michelle Schwan]

Just installed pgAdmin v4.7 from v4.6 with no issues.

I found a bug.

Go to Views and select SQL.  Click on a view and receive an error message.  
This was not happening in v4.6.
[cid:image001.png@01D516EB.CC427250]


Thanks,
Michelle