NoSuchModuleError:无法加载插件:sqlalchemy.dialects:redshift.psycopg2 [英] NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:redshift.psycopg2

问题描述

我正在尝试从我的 Python 代码连接到 redshift.我的 pip 已安装:

I am trying to connect to redshift from my python code. my pip installed:

psycopg2==2.6.1
redshift-sqlalchemy==0.4.1
SQLAlchemy==1.0.9

我的虚拟机有:

libpq-dev
python-psycopg2

但我仍然得到

 engine = create_engine('redshift+psycopg2://{}:{}@{}'.format(username, password, url))
  File "/opt/project/env/local/lib/python2.7/site-packages/sqlalchemy/engine/__init__.py", line 386, in create_engine
    return strategy.create(*args, **kwargs)
  File "/opt/project/env/local/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 51, in create
    entrypoint = u._get_entrypoint()
  File "/opt/project/env/local/lib/python2.7/site-packages/sqlalchemy/engine/url.py", line 131, in _get_entrypoint
    cls = registry.load(name)
  File "/opt/project/env/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 205, in load
    (self.group, name))
NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:redshift.psycopg2

使用相同的配置，我可以在我的笔记本电脑 (mac) 上运行，但是在 linux 上，我猜仍然缺少一些软件包?任何建议将不胜感激，谢谢！

With the same config, I am able to run from my laptop (mac), but on linux, I guess some packages still missing? Any suggestion will be appreciated, thanks!

推荐答案

我遇到了同样的问题，下面的解决方案顺利解决了.

I faced same issue and bellow resolution solved it smoothly .

环境:

Python 3.7

康达 4.6.14

依赖:

sudo apt-get install python-pip

sudo apt-get install python-pip

sudo apt-get install libpq-dev

sudo apt-get install libpq-dev

pip install --user psycopg2

pip install --user psycopg2

pip install --user sqlalchemy

pip install --user sqlalchemy

pip install --user sqlalchemy-redshift

pip install --user sqlalchemy-redshift

连接字符串:

connection_string = sa_url.URL(
        drivername='postgresql+psycopg2',
        username='admin',
        password='admin',
        host='redshiftone.********.us-west-2.redshift.amazonaws.com',
        port='5439',
        database='redshiftone')

这篇关于NoSuchModuleError:无法加载插件:sqlalchemy.dialects:redshift.psycopg2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！