ImportError: dlopen(/lib/python3.10/site-packages/psycopg2/_psycopg.cpython-310-darwin.so, 0x0002):

오류 메세지

Traceback (most recent call last):
  File "/경로/파일명.py", line 4, in <module>
    import proc4_poi
  File "/경로/파일명.py", line 5, in <module>
    import user_fn
  File "/경로/파일명.py", line 7, in <module>
    import psycopg2
  File "/경로/lib/python3.10/site-packages/psycopg2/__init__.py", line 51, in <module>
    from psycopg2._psycopg import (                     # noqa
ImportError: dlopen(/경로/.pyenv/versions/3.10.9/경로/lib/python3.10/site-packages/psycopg2/_psycopg.cpython-310-darwin.so, 0x0002): 
Library not loaded: /opt/homebrew/opt/postgresql@14/lib/postgresql@14/libpq.5.dylib
  Referenced from: /경로/lib/python3.10/site-packages/psycopg2/_psycopg.cpython-310-darwin.so
  Reason: tried: '/opt/homebrew/opt/postgresql@14/lib/postgresql@14/libpq.5.dylib' (no such file), '/usr/local/lib/libpq.5.dylib' (no such file), '/usr/lib/libpq.5.dylib' (no such file)

 

위와 같은 오류가 나오면 

홈브르에 postgresql@14 버전이 설치가 안되어있으니 설치하라는 뜻이다.

 

설치하고 나면 제대로 작동하는 것을 확인할 수 있다.