Thread: no results in 4.11 Ubuntu
I'm not getting any results from any query in pgAdmin 4.11 on Ubuntu. I only get a message:
'table_oid'
I've tried on two Ubuntu 18.04 based computers (XUbuntu and Mint) in Firefox and Chrome against 3 servers. Queries in pgAdminIII and psql are fine. My "about" info below:
Version
4.11
Copyright
Copyright (C) 2013 - 2019, The pgAdmin Development Team
Python Version
3.6.8 (default, Jan 14 2019, 11:02:34) [GCC 8.0.1 20180414 (experimental) [trunk revision 259383]]
Flask Version
0.12.2
Application Mode
Desktop
Current User
Richard W. Greenwood, PLS
www.greenwoodmap.com
www.greenwoodmap.com
Richard,
Congratulations, you too have been hit by the mis-packaged pgAdmin4.11 bug recorded as Issue # 4520 (among others) .
TLDR version; pgAdmin 4.11 is dependent on a version of psycopg2 that isn't in the repository (any repository) and wasn't included in the pgAdmin4 installer package for Linux versions. There is a workaround listed in that bug report of side loading the library and manually tweaking some paths.
They are aware of the issue, and someone(s) is/are working on it. I hope it's resolved soon (I've been bitten by the same issue).
So patience, hope, and try the workaround if you're comfortable with that sort of thing.
Good luck,
rik.
On Thu, Aug 1, 2019 at 8:52 AM Richard Greenwood <richard.greenwood@gmail.com> wrote:
I'm not getting any results from any query in pgAdmin 4.11 on Ubuntu. I only get a message:'table_oid'I've tried on two Ubuntu 18.04 based computers (XUbuntu and Mint) in Firefox and Chrome against 3 servers. Queries in pgAdminIII and psql are fine. My "about" info below:Version4.11CopyrightCopyright (C) 2013 - 2019, The pgAdmin Development TeamPython Version3.6.8 (default, Jan 14 2019, 11:02:34) [GCC 8.0.1 20180414 (experimental) [trunk revision 259383]]Flask Version0.12.2Application ModeDesktopCurrent User--Richard W. Greenwood, PLS
www.greenwoodmap.com
Thanks for the info. Do I really have to create an account just to view the issue? The link you sent just goes to a postgresql.org "sign in" page.
On Thu, Aug 1, 2019 at 6:58 AM richard coleman <rcoleman.ascentgl@gmail.com> wrote:
Richard,Congratulations, you too have been hit by the mis-packaged pgAdmin4.11 bug recorded as Issue # 4520 (among others) .TLDR version; pgAdmin 4.11 is dependent on a version of psycopg2 that isn't in the repository (any repository) and wasn't included in the pgAdmin4 installer package for Linux versions. There is a workaround listed in that bug report of side loading the library and manually tweaking some paths.They are aware of the issue, and someone(s) is/are working on it. I hope it's resolved soon (I've been bitten by the same issue).So patience, hope, and try the workaround if you're comfortable with that sort of thing.Good luck,rik.On Thu, Aug 1, 2019 at 8:52 AM Richard Greenwood <richard.greenwood@gmail.com> wrote:I'm not getting any results from any query in pgAdmin 4.11 on Ubuntu. I only get a message:'table_oid'I've tried on two Ubuntu 18.04 based computers (XUbuntu and Mint) in Firefox and Chrome against 3 servers. Queries in pgAdminIII and psql are fine. My "about" info below:Version4.11CopyrightCopyright (C) 2013 - 2019, The pgAdmin Development TeamPython Version3.6.8 (default, Jan 14 2019, 11:02:34) [GCC 8.0.1 20180414 (experimental) [trunk revision 259383]]Flask Version0.12.2Application ModeDesktopCurrent User--Richard W. Greenwood, PLS
www.greenwoodmap.com
Richard W. Greenwood, PLS
www.greenwoodmap.com
www.greenwoodmap.com
Richard,
As far as I know, yea, though you can use your GMail or Outlook accounts as well, if you have one.
rik.
On Thu, Aug 1, 2019 at 9:31 AM Richard Greenwood <richard.greenwood@gmail.com> wrote:
Thanks for the info. Do I really have to create an account just to view the issue? The link you sent just goes to a postgresql.org "sign in" page.On Thu, Aug 1, 2019 at 6:58 AM richard coleman <rcoleman.ascentgl@gmail.com> wrote:Richard,Congratulations, you too have been hit by the mis-packaged pgAdmin4.11 bug recorded as Issue # 4520 (among others) .TLDR version; pgAdmin 4.11 is dependent on a version of psycopg2 that isn't in the repository (any repository) and wasn't included in the pgAdmin4 installer package for Linux versions. There is a workaround listed in that bug report of side loading the library and manually tweaking some paths.They are aware of the issue, and someone(s) is/are working on it. I hope it's resolved soon (I've been bitten by the same issue).So patience, hope, and try the workaround if you're comfortable with that sort of thing.Good luck,rik.On Thu, Aug 1, 2019 at 8:52 AM Richard Greenwood <richard.greenwood@gmail.com> wrote:I'm not getting any results from any query in pgAdmin 4.11 on Ubuntu. I only get a message:'table_oid'I've tried on two Ubuntu 18.04 based computers (XUbuntu and Mint) in Firefox and Chrome against 3 servers. Queries in pgAdminIII and psql are fine. My "about" info below:Version4.11CopyrightCopyright (C) 2013 - 2019, The pgAdmin Development TeamPython Version3.6.8 (default, Jan 14 2019, 11:02:34) [GCC 8.0.1 20180414 (experimental) [trunk revision 259383]]Flask Version0.12.2Application ModeDesktopCurrent User--Richard W. Greenwood, PLS
www.greenwoodmap.com--Richard W. Greenwood, PLS
www.greenwoodmap.com