Re: Is pgadmin4 being developed at Microsoft?

pip install psycopg2-binary

On Tue, Oct 15, 2019 at 9:37 AM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi Alex,

On Tue, Oct 15, 2019 at 12:19 AM Alex Williams <valenceshell@protonmail.com> wrote:

Because it sure seems like it. Every update to pgadmin4 breaks something. I continuously have to use it in a vm to revert back to a snapshot because either there's an issue with python or some other package and have to spend hours debugging why I can't get it to start.

This is getting to be worse than Windows 10 updates.

I had a working pgadmin4, forgot the specific version that was working (had to get rid of snapshots on one box to reduce space so I could shrink the vm) and now I get this after the latest update on Centos7

Traceback (most recent call last):

  File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgAdmin4.py", line 97, in <module>

    app = create_app()

  File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/__init__.py", line 400, in create_app

    driver.init_app(app)

  File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/__init__.py", line 40, in init_app

    DriverRegistry.load_drivers()

  File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/registry.py", line 88, in load_drivers

    module = import_module(module_name)

  File "/usr/lib64/python2.7/importlib/__init__.py", line 37, in import_module

    __import__(name)

  File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/psycopg2/__init__.py", line 20, in <module>

    import psycopg2

  File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 50, in <module>

    from psycopg2._psycopg import (                     # noqa

ImportError: /usr/lib64/python2.7/site-packages/psycopg2/_psycopg.so: undefined symbol: PQencryptPasswordConn

PQencryptPasswordConn is introduced in the libpq from the PostgreSQL 10.

psycopg2 uses the libpq from the system.

You may need to install/upgrade PG 10+ client libraries for the same.

-- Thanks, Ashesh

What is python-psycopg2 version on your system?

If, possible upgrade the pgAdmin 4 to the latest one.

Thanks,

Khushboo 

Sent with ProtonMail Secure Email.