(MAC Big Sur 12.1) ImportError: dlopen libpq

python error macos

字数统计: 203阅读时长: 1 min

 2022/01/26 

问题

在python脚本中连接postgres时遇到以下问题：

Traceback (most recent call last):
  File "/Users/shenshijie/Documents/app/postgres/connect.py", line 2, in <module>
    import psycopg2
  File "/opt/homebrew/lib/python3.9/site-packages/psycopg2/__init__.py", line 51, in <module>
    from psycopg2._psycopg import (                     # noqa
ImportError: dlopen(/opt/homebrew/lib/python3.9/site-packages/psycopg2/_psycopg.cpython-39-darwin.so, 0x0002): Library not loaded: /opt/homebrew/opt/postgresql/lib/libpq.5.dylib
  Referenced from: /opt/homebrew/lib/python3.9/site-packages/psycopg2/_psycopg.cpython-39-darwin.so
  Reason: tried: '/opt/homebrew/opt/postgresql/lib/libpq.5.dylib' (no such file), '/usr/local/lib/libpq.5.dylib' (no such file), '/usr/lib/libpq.5.dylib' (no such file)

解决

在我的Mac BigSur 12.1 M1遇到以上问题，按顺序执行以下命令顺利解决：

$ pip3 uninstall psycopg2
$ brew install libpq --build-from-source
$ echo 'export LDFLAGS="-L/opt/homebrew/opt/libpq/lib"' >> ~/.zshrc
$ pip3 install psycopg2 --no-cache-dir

以上。

原文作者：Saki Shum

原文链接：https://sakishum.com/2022/01/26/MAC-Big-Sur-12-1-ImportError-dlopen-libpq/

发表日期：一月 26日 2022, 12:03:29 凌晨

更新日期：一月 26日 2022, 9:26:53 上午