Can't load plugin: sqlalchemy.dialects:postgres

Open abduistheusername opened this issue 3 years ago • 2 comments

How can i override this issue?

File "C:\Users\PC\codmeric\test_prject\venv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 343, in load raise exc.NoSuchModuleError( sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:postgres

Dec 27 '22 07:12 abduistheusername

@abduistheusername , it looks like the db URL contains postgres, but the library required for postgres may not be installed? Does the error not suggest a missing library?

Dec 28 '22 08:12 codemation

hello @abduistheusername, I think it will resolve your issue:

SQLAlchemy 1.4 removed the deprecated postgres dialect name, the name postgresql must be used instead now. The dialect is the part before the :// in the URL. SQLAlchemy 1.3 and earlier showed a deprecation warning but still accepted it.

So in your json config file change DB_TYPE from postgres to postgresql

It worked for me.

Rémy

Feb 06 '23 14:02 remydewa