Re: [EXTERNAL] - Re: pgAdmin IV

[Aditya Toshniwal]

Hi Michelle,

On Wed, Jun 5, 2019 at 12:42 AM Michelle Schwan 
wrote:

> Aditya,
>
>
>
> That is not very intuitive!  Why can’t the information be displayed?  All
> of the other database tools for other databases allow this.
>
This can be done if we split the JSON data and show it in multiple rows.
Kindly raise a feature request here-
https://redmine.postgresql.org/projects/pgadmin4/issues/new

>
>
> Thanks,
>
> Michelle
>
>
>
> *From:* Aditya Toshniwal 
> *Sent:* Tuesday, June 04, 2019 10:50 AM
> *To:* Michelle Schwan 
> *Cc:* pgadmin-support lists.postgresql.org <
> 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  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.
>
>
>
> Same query in pgAdmin III
>
>
>
> Thanks,
>
> Michelle Schwan
>
> Database Architect
>
> msch...@opentext.com
>
> Phone: (519) 888 7111 ext 3241
>
> Website:
>
> www.opentext.com
>
>
>
> [image:
> http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]
> 
>
> 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.
>
>
>
>

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

Re: pgAdmin IV

[Khushboo Vashi]

Hi,

Please log the issue @ https://redmine.postgresql.org/projects/pgadmin4

Thanks,
Khushboo

On Tue, Jun 4, 2019 at 7:46 PM Michelle Schwan  wrote:

> 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.
>
>
>
>
>
> Thanks,
>
> Michelle Schwan
>
> Database Architect
>
> msch...@opentext.com
>
> Phone: (519) 888 7111 ext 3241
>
> Website:
>
> www.opentext.com
>
>
>
> [image:
> http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]
> 
>
> 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.
>
>
>

Re: pgAdmin in text only

[Khushboo Vashi]

On Tue, Jun 4, 2019 at 8:00 PM  wrote:

>
>
> Hi there,
>
>
>
> Trying to install PostgreSQL 9.6 and pgAdmin4 on Centos 7 for lab testing
> purposes but some these is the web interface that I am getting at for
> localhost/pgadmin4.  I believe I was to display it properly last two weeks
> ago but since V4.7 this is the display that I am getting at.  I saw
> something similar in the FAQ (https://www.pgadmin.org/faq/#6) but it’s
> for Windows only.  Any idea what I am missing? The command I use is sudo
> yum -y install epel-release followed by sudo yum -y install pgadmin4
>
This issue has already been reported. (Ref:
https://redmine.postgresql.org/issues/4313)
Please refer this RM to know the progress on this issue.

>
>
>
>
> Thanks,
>
> Jeffrey
>

Re: centos 7 / pgadmin 4.7

[Khushboo Vashi]

Hi Alex,

Can you please test the latest packages released by the packager as
mentioned in the RM https://redmine.postgresql.org/issues/4313?

Thanks,
Khushboo

On Tue, Jun 4, 2019 at 10:03 PM Alex Williams 
wrote:

> Also, I've updated the ticket with the info below and the solution from
> Mike is working:
>
> *yum downgrade pgadmin4-python-flask*
>
> https://redmine.postgresql.org/issues/4313
>
> [root@centos7dev output]# yum downgrade pgadmin4-python-flask
> Loaded plugins: fastestmirror, langpacks
> Loading mirror speeds from cached hostfile
> epel/x86_64/metalink | 19 kB 00:00:00 * base: mirror.atlanticmetro.net *
> epel: ewr.edge.kernel.org * extras: mirror.atlanticmetro.net *
> nux-dextop: mirror.li.nux.ro * updates: mirror.atlanticmetro.net
> adobe-linux-x86_64 | 2.9 kB 00:00:00
> base | 3.6 kB 00:00:00
> extras | 3.4 kB 00:00:00
> google-talkplugin | 951 B 00:00:00
> nux-dextop | 2.9 kB 00:00:00
> pgdg10 | 3.6 kB 00:00:00
> pgdg11 | 3.6 kB 00:00:00
> pgdg94 | 3.6 kB 00:00:00
> pgdg95 | 3.6 kB 00:00:00
> pgdg96 | 3.6 kB 00:00:00
> skype-stable | 2.9 kB 00:00:00
> updates | 3.4 kB 00:00:00
> Resolving Dependencies
> --> Running transaction check
> ---> Package pgadmin4-python-flask.noarch 1:0.12.4-1.rhel7 will be a
> downgrade
> ---> Package pgadmin4-python-flask.noarch 1:1.0.2-1.rhel7 will be erased
> --> Finished Dependency Resolution
>
> Dependencies Resolved
>
>
> ===
> Package Arch Version Repository Size
> ===
> Downgrading:
> pgadmin4-python-flask noarch 1:0.12.4-1.rhel7 pgdg10 132 k
>
> Transaction Summary
> ===
> Downgrade 1 Package
>
> Total download size: 132 k
> Is this ok [y/d/N]: y
> Downloading packages:
> pgadmin4-python-flask-0.12.4-1.rhel7.noarch.rpm | 132 kB 00:00:01
> Running transaction check
> Running transaction test
> Transaction test succeeded
> Running transaction
> Installing : 1:pgadmin4-python-flask-0.12.4-1.rhel7.noarch 1/2
> Cleanup : 1:pgadmin4-python-flask-1.0.2-1.rhel7.noarch 2/2
> Verifying : 1:pgadmin4-python-flask-0.12.4-1.rhel7.noarch 1/2
> Verifying : 1:pgadmin4-python-flask-1.0.2-1.rhel7.noarch 2/2
>
> Removed:
> pgadmin4-python-flask.noarch 1:1.0.2-1.rhel7
>
> Installed:
> pgadmin4-python-flask.noarch 1:0.12.4-1.rhel7
>
> Complete!
> [root@centos7dev output]#
>
>
>
> Sent with ProtonMail  Secure Email.
>
> ‐‐‐ Original Message ‐‐‐
> On Tuesday, June 4, 2019 12:20 PM, Alex Williams <
> valencesh...@protonmail.com> wrote:
>
> Also, if I try to open those javascripts directly, I get the following
> responses:
> require.min.js:
> info
> ""
> errormsg
> "make_conditional() got an unexpected keyword argument 'accept_ranges'"
> data
> null
> result
> null
> success
> 0
>
> vendor.js:
> nfo
> ""
> errormsg
> "make_conditional() got an unexpected keyword argument 'accept_ranges'"
> data
> null
> result
> null
> success
> 0
>
> pgadmin_commons.js:
> info
> ""
> errormsg
> "make_conditional() got an unexpected keyword argument 'accept_ranges'"
> data
> null
> result
> null
> success
> 0
>
> Sent with ProtonMail  Secure Email.
>
> ‐‐‐ Original Message ‐‐‐
> On Tuesday, June 4, 2019 11:38 AM, Alex Williams <
> valencesh...@protonmail.com> wrote:
>
> Thank you bothalso, here's is the console output when opening pgadmin
> on the browser:
>
> Loading failed for the 

Re: pgAdmin4 4.8 Kubuntu issues

[Michel Feinstein]

It would be easier if the system when prompting for the Master Password,
had a "I don't want to define a Master Password" or something like that,
which would set that config_local.py property automatically.

On Tue, Jun 4, 2019, 18:06 Cherio  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 <
> 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: pgAdmin4 4.8 Kubuntu issues

[Cherio]

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

pgAdmin4 4.8 Kubuntu issues

[richard coleman]

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
Phone: (519) 888 7111 ext 3241
Website:
www.opentext.com

[http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]

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.

Re: centos 7 / pgadmin 4.7

[Alex Williams]

Also, I've updated the ticket with the info below and the solution from Mike is 
working:

yum downgrade pgadmin4-python-flask

https://redmine.postgresql.org/issues/4313

[root@centos7dev output]# yum downgrade pgadmin4-python-flask
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
epel/x86_64/metalink | 19 kB 00:00:00 * base: mirror.atlanticmetro.net * epel: 
ewr.edge.kernel.org * extras: mirror.atlanticmetro.net * nux-dextop: 
mirror.li.nux.ro * updates: mirror.atlanticmetro.net
adobe-linux-x86_64 | 2.9 kB 00:00:00
base | 3.6 kB 00:00:00
extras | 3.4 kB 00:00:00
google-talkplugin | 951 B 00:00:00
nux-dextop | 2.9 kB 00:00:00
pgdg10 | 3.6 kB 00:00:00
pgdg11 | 3.6 kB 00:00:00
pgdg94 | 3.6 kB 00:00:00
pgdg95 | 3.6 kB 00:00:00
pgdg96 | 3.6 kB 00:00:00
skype-stable | 2.9 kB 00:00:00
updates | 3.4 kB 00:00:00
Resolving Dependencies
--> Running transaction check
---> Package pgadmin4-python-flask.noarch 1:0.12.4-1.rhel7 will be a downgrade
---> Package pgadmin4-python-flask.noarch 1:1.0.2-1.rhel7 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

===
Package Arch Version Repository Size 
===
Downgrading:
pgadmin4-python-flask noarch 1:0.12.4-1.rhel7 pgdg10 132 k

Transaction Summary 
===
Downgrade 1 Package

Total download size: 132 k
Is this ok [y/d/N]: y
Downloading packages:
pgadmin4-python-flask-0.12.4-1.rhel7.noarch.rpm | 132 kB 00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : 1:pgadmin4-python-flask-0.12.4-1.rhel7.noarch 1/2
Cleanup : 1:pgadmin4-python-flask-1.0.2-1.rhel7.noarch 2/2
Verifying : 1:pgadmin4-python-flask-0.12.4-1.rhel7.noarch 1/2
Verifying : 1:pgadmin4-python-flask-1.0.2-1.rhel7.noarch 2/2

Removed:
pgadmin4-python-flask.noarch 1:1.0.2-1.rhel7

Installed:
pgadmin4-python-flask.noarch 1:0.12.4-1.rhel7

Complete!
[root@centos7dev output]#

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

‐‐‐ Original Message ‐‐‐
On Tuesday, June 4, 2019 12:20 PM, Alex Williams  
wrote:

> Also, if I try to open those javascripts directly, I get the following 
> responses:
> require.min.js:
> info
> ""
>
> errormsg
> "make_conditional() got an unexpected keyword argument 'accept_ranges'"
>
> data
> null
>
> result
> null
>
> success
> 0
>
> vendor.js:
> nfo
> ""
>
> errormsg
> "make_conditional() got an unexpected keyword argument 'accept_ranges'"
>
> data
> null
>
> result
> null
>
> success
> 0
>
> pgadmin_commons.js:
> info
> ""
>
> errormsg
> "make_conditional() got an unexpected keyword argument 'accept_ranges'"
>
> data
> null
>
> result
> null
>
> success
> 0
>
> Sent with [ProtonMail](https://protonmail.com) Secure Email.
>
> ‐‐‐ Original Message ‐‐‐
> On Tuesday, June 4, 2019 11:38 AM, Alex Williams 
>  wrote:
>
>> Thank you bothalso, here's is the console output when opening pgadmin on 
>> the browser:
>>
>> Loading failed for the 

Re: centos 7 / pgadmin 4.7

[Alex Williams]

Also, if I try to open those javascripts directly, I get the following 
responses:
require.min.js:
info
""

errormsg
"make_conditional() got an unexpected keyword argument 'accept_ranges'"

data
null

result
null

success
0

vendor.js:
nfo
""

errormsg
"make_conditional() got an unexpected keyword argument 'accept_ranges'"

data
null

result
null

success
0

pgadmin_commons.js:
info
""

errormsg
"make_conditional() got an unexpected keyword argument 'accept_ranges'"

data
null

result
null

success
0

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

‐‐‐ Original Message ‐‐‐
On Tuesday, June 4, 2019 11:38 AM, Alex Williams  
wrote:

> Thank you bothalso, here's is the console output when opening pgadmin on 
> the browser:
>
> Loading failed for the 

Re: centos 7 / pgadmin 4.7

[Alex Williams]

Thank you bothalso, here's is the console output when opening pgadmin on 
the browser:

Loading failed for the 

Re: pgAdmin IV

[Aditya Toshniwal]

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  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.
>
>
>
> Same query in pgAdmin III
>
>
>
> Thanks,
>
> Michelle Schwan
>
> Database Architect
>
> msch...@opentext.com
>
> Phone: (519) 888 7111 ext 3241
>
> Website:
>
> www.opentext.com
>
>
>
> [image:
> http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]
> 
>
> 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
Phone: (519) 888 7111 ext 3241
Website:
www.opentext.com

[http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]

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
Phone: (519) 888 7111 ext 3241
Website:
www.opentext.com

[http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]

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
Phone: (519) 888 7111 ext 3241
Website:
www.opentext.com

[http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]

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.

Re: login role password

[Michael Shapiro]

Thanks.  That is a helpful workaround.

I am asking for this functionality to be added to PgAdmin4, so that when
you select the SQL for a login role you see what PgAdmin3 shows.

  CREATE ROLE xxx_user LOGIN
ENCRYPTED PASSWORD 'md5f349771b7d83b170e8377bd7d09'
SUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION;

And that the dialog for a login user supports setting an encrypted password.

I know I can run this in an SQL window:

  ALTER ROLE xxx_user ENCRYPTED PASSWORD 'md5f349771b7d83b170e8377bd7d09';

but it would be nice if PgAdmin4 supported this in the GUI

On Tue, Jun 4, 2019 at 8:40 AM Isaías Sánchez 
wrote:

> Just: select * from pg_authid;
>
> En 4 de junio de 2019 15:14:49 Michael Shapiro 
> escribió:
>
>> PgAdmin3 has the ability to see the encrypted password for a login role.
>> That allow me to copy the login role password from one server to another
>> (without having to know the password).
>>
>> I don't see how to see the encrypted password for a login role in PgAdmin4
>>
>>
>

Re: login role password

[Isaías Sánchez]

Just: select * from pg_authid;

En 4 de junio de 2019 15:14:49 Michael Shapiro  escribió:
PgAdmin3 has the ability to see the encrypted password for a login role. 
That allow me to copy the login role password from one server to another 
(without having to know the password).


I don't see how to see the encrypted password for a login role in PgAdmin4

Re: 4.8 docs build error

[Christoph Berg]

Re: To pgAdmin III support 2019-06-04 <20190604124400.ga4...@msg.df7cb.de>
> The problem is in docs/en_US/build_code_snippet.py:

Christoph
--- a/docs/en_US/build_code_snippet.py
+++ b/docs/en_US/build_code_snippet.py
@@ -32,8 +32,7 @@ This document contains code for some of
 below:\n\n""")
 
 for m in [
-'PgAdminModule', 'NodeView',
-'BaseDriver', 'BaseConnection'
+'PgAdminModule',
 ]:
 target.write("* {0}_\n".format(m))
 

4.8 docs build error

[Christoph Berg]

reading sources... [ 95%] unique_constraint_dialog
reading sources... [ 96%] user_interface
reading sources... [ 97%] user_management
reading sources... [ 98%] user_mapping_dialog
reading sources... [ 99%] using_pgagent
reading sources... [100%] view_dialog


Warning, treated as error:
/home/cbe/projects/postgresql/pgadmin4/pgadmin4/docs/en_US/code_snippets.rst:10:Unknown
 target name: "nodeview".
make[3]: *** [Makefile.sphinx:47: html] Fehler 2


The problem is in docs/en_US/build_code_snippet.py:

for m in [
'PgAdminModule', 'NodeView',
'BaseDriver', 'BaseConnection'
]:
target.write("* {0}_\n".format(m))


Christoph