Re: PGAdmin4.11.1 on Ubuntu 18.04

> >> What repo are you getting the packages from? > > Repo looks like PostgreSQL apt repository https://apt.postgresql.org. .../bionic-pgdg.main > -- > Adrian Klaver > adrian.kla...@aklaver.com >

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 8/1/19 9:05 AM, Daniele Varrazzo wrote: On Thu, Aug 1, 2019 at 4:43 PM Adrian Klaver wrote: Yeah the requirements file shows psycopg2-2.8: https://github.com/postgres/pgadmin4/blob/master/requirements.txt The issue(I'm assuming) is: http://initd.org/psycopg/articles/2019/04/04/psycopg-28-

Re: PGAdmin4.11.1 on Ubuntu 18.04

On Thu, Aug 1, 2019 at 4:43 PM Adrian Klaver wrote: > Yeah the requirements file shows psycopg2-2.8: > https://github.com/postgres/pgadmin4/blob/master/requirements.txt > > The issue(I'm assuming) is: > > http://initd.org/psycopg/articles/2019/04/04/psycopg-28-released/ > "Added table_oid and tab

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 01/08/2019 16:32, Tony Shelver wrote: The article at stackoverflow is here Thanks for the link! The solution given in one of the comments there worked for me (Debian 9): - Install pip3 if needed: su

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 8/1/19 8:28 AM, Tony Shelver wrote: Thanks for the replies: the version is PG11.4. I tried to uninstall pgAdmin4, then install psycopg 2.8 via pip, then reinstall pgadmoin4 again using the Synatpic / Ubunto package manager, but it just installs pscopg2.7 over the top. If you are insta

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 8/1/19 8:28 AM, Tony Shelver wrote: Thanks for the replies: the version is PG11.4. I tried to uninstall pgAdmin4, then install psycopg 2.8 via pip, then reinstall pgadmoin4 again using the Synatpic / Ubunto package manager, but it just installs pscopg2.7 over the top. What repo are you

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 8/1/19 8:34 AM, Ron wrote: I think the real question is "how do I make pgadmin4 use the locally installed psycopg instead of the system version?" Yeah the requirements file shows psycopg2-2.8: https://github.com/postgres/pgadmin4/blob/master/requirements.txt The issue(I'm assuming) is: h

Re: PGAdmin4.11.1 on Ubuntu 18.04

I think the real question is "how do I make pgadmin4 use the locally installed psycopg instead of the system version?" On 8/1/19 10:32 AM, Tony Shelver wrote: The article at stackoverflow is here On Thu

Re: PGAdmin4.11.1 on Ubuntu 18.04

The article at stackoverflow is here On Thu, 1 Aug 2019 at 17:28, Tony Shelver wrote: > Thanks for the replies: the version is PG11.4. > > As for needing to upgrade: I just want to fix the problem. This

Re: PGAdmin4.11.1 on Ubuntu 18.04

Thanks for the replies: the version is PG11.4. As for needing to upgrade: I just want to fix the problem. This was a working environment until I updated pgAdmin4. The fix suggested on Stackoverflow was to move to psycopg2 2.8, but it doesn't seem to be possible. If there is another fix that an

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 8/1/19 7:39 AM, Tony Shelver wrote: I am getting an 'able oid' when querying any tables using the Query tool. When using the view / edit data option, everything works fine. Should have asked in previous post: What Postgres version(s)? I came across this <<< The problem is due to python3

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 8/1/19 7:39 AM, Tony Shelver wrote: I am getting an 'able oid' when querying any tables using the Query tool. Can you show the actual entire error message? More below. When using the view / edit data option, everything works fine. I came across this <<< The problem is due to python3-ps

PGAdmin4.11.1 on Ubuntu 18.04

I am getting an 'able oid' when querying any tables using the Query tool. When using the view / edit data option, everything works fine. I came across this <<< The problem is due to python3-psycopg2. The latest pgadmin4 version requires psycopg2-2.8. But if you're on Debian/Ubuntu stable, apt ins