Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can't load plugin: sqlalchemy.dialects:postgres #81

Open
abduistheusername opened this issue Dec 27, 2022 · 2 comments
Open

Can't load plugin: sqlalchemy.dialects:postgres #81

abduistheusername opened this issue Dec 27, 2022 · 2 comments

Comments

@abduistheusername
Copy link

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

@codemation
Copy link
Owner

@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?

@remydewa
Copy link

remydewa commented Feb 6, 2023

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants