Thanks, Searching around for about 2 hours, downgrading/upgrading etc.... the stackoverflow page resolved this issue this time (link below.) Will keep this version for the foreseeable future and will block any further updates, as it does what I need, querying and exporting.
https://stackoverflow.com/questions/56379922/issue-with-libpq-so-5-and-pqencryptpasswordconn-version-rhpg-10-on-fedora30 specifically: pip install psycopg2 - binary Sent with [ProtonMail](https://protonmail.com) Secure Email. ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Tuesday, October 15, 2019 1:39 AM, Ashesh Vashi <ashesh.va...@enterprisedb.com> wrote: > On Tue, Oct 15, 2019 at 9:37 AM Khushboo Vashi > <khushboo.va...@enterprisedb.com> wrote: > >> Hi Alex, >> >> On Tue, Oct 15, 2019 at 12:19 AM Alex Williams <valencesh...@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](https://protonmail.com) Secure Email.
