当我尝试导入psycopg2时,会收到以下错误消息:
ImportError: dlopen(/opt/homebrew/lib/python3.10/site-packages/psycopg2/_psycopg.cpython-310-darwin.so, 0x0002): Library not loaded: /opt/homebrew/opt/postgresql/lib/libpq.5.dylib
Referenced from: /opt/homebrew/lib/python3.10/site-packages/psycopg2/_psycopg.cpython-310-darwin.so
Reason: tried: '/opt/homebrew/opt/postgresql/lib/libpq.5.dylib' (no such file), '/usr/local/lib/libpq.5.dylib' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e')), '/usr/lib/libpq.5.dylib' (no such file), '/opt/homebrew/Cellar/postgresql@14/14.5_3/lib/libpq.5.dylib' (no such file), '/usr/local/lib/libpq.5.dylib' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e')), '/usr/lib/libpq.5.dylib' (no such file)有人知道如何解决这个错误吗?
发布于 2022-09-13 09:03:02
我在一些Postgres升级上也遇到了同样的问题。重新安装psycopg2-binary解决了这个问题,因为对我来说这是一个缓存问题。
pip install psycopg2-binary --force-reinstall --no-cache-dir发布于 2022-09-06 20:01:35
对于Mac M1用户;
pip install -i https://test.pypi.org/simple/ psycopg2-binary==2.9.3这将解决问题。
谢谢
发布于 2022-09-26 11:42:11
https://github.com/PostgresApp/PostgresApp/issues/83#issuecomment-1232400894
ln -s /opt/homebrew/opt/postgresql/lib/postgresql@14/* /opt/homebrew/opt/postgresql/lib/为我工作
https://stackoverflow.com/questions/73625820
复制相似问题