Обсуждение: Is pgadmin4 being developed at Microsoft?

Поиск
Список
Период
Сортировка

Is pgadmin4 being developed at Microsoft?

От
Alex Williams
Дата:
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.

Re: Is pgadmin4 being developed at Microsoft?

От
Cherio
Дата:
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 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.

Re: Is pgadmin4 being developed at Microsoft?

От
Khushboo Vashi
Дата:
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

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.

Re: Is pgadmin4 being developed at Microsoft?

От
Ashesh Vashi
Дата:
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.

Re: Is pgadmin4 being developed at Microsoft?

От
Alex Williams
Дата:
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 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.