Thread: Is pgadmin4 being developed at Microsoft?
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
Sent with ProtonMail Secure Email.
I hate to contribute to a non-constructive subject but sadly pgadmin 4 quality has plenty of room for improvement. I get that impression that development strongly favors new features to stability making the product of the kind of quality I can't trust. I have to wait for each release to be tested by others and then cherry pick releases and jump selectively e.g. from release 10 to 13 in order to avoid critical - in my ability to trust it with my data - bugs. I can't think of another product in my daily use that I trust less than PgAdmin which is kinda sad when I compare it with e.g. PostgreSQL server almost rock-solid stability.
These were my 2 cents of useless rambling )))
On Mon, Oct 14, 2019 at 3:27 PM 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 Centos7Traceback (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_appdriver.init_app(app)File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/__init__.py", line 40, in init_appDriverRegistry.load_drivers()File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/registry.py", line 88, in load_driversmodule = 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 psycopg2File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 50, in <module>from psycopg2._psycopg import ( # noqaImportError: /usr/lib64/python2.7/site-packages/psycopg2/_psycopg.so: undefined symbol: PQencryptPasswordConnSent with ProtonMail Secure Email.
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 Centos7Traceback (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_appdriver.init_app(app)File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/__init__.py", line 40, in init_appDriverRegistry.load_drivers()File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/registry.py", line 88, in load_driversmodule = 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 psycopg2File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 50, in <module>from psycopg2._psycopg import ( # noqaImportError: /usr/lib64/python2.7/site-packages/psycopg2/_psycopg.so: undefined symbol: PQencryptPasswordConn
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.
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 Centos7Traceback (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_appdriver.init_app(app)File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/__init__.py", line 40, in init_appDriverRegistry.load_drivers()File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/registry.py", line 88, in load_driversmodule = 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 psycopg2File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 50, in <module>from psycopg2._psycopg import ( # noqaImportError: /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,KhushbooSent with ProtonMail Secure Email.
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.
specifically:
pip install psycopg2-binary
Sent with ProtonMail Secure Email.
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Tuesday, October 15, 2019 1:39 AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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 Centos7Traceback (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_appdriver.init_app(app)File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/__init__.py", line 40, in init_appDriverRegistry.load_drivers()File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/registry.py", line 88, in load_driversmodule = 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 psycopg2File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 50, in <module>from psycopg2._psycopg import ( # noqaImportError: /usr/lib64/python2.7/site-packages/psycopg2/_psycopg.so: undefined symbol: PQencryptPasswordConnPQencryptPasswordConn 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, AsheshWhat is python-psycopg2 version on your system?If, possible upgrade the pgAdmin 4 to the latest one.Thanks,KhushbooSent with ProtonMail Secure Email.