Hello, I’m new to meltano and attempting to install on Mac High Sierra (10.13). After installing meltano, when I check it with

meltano --version

, I get the following error with installing psycopg2:

Traceback (most recent call last):
  File "/Users/Documents/nested-knowledge/nk-operations/.venv/bin/meltano"
, line 5, in <module>
    from meltano.cli import main
  File "/Users/Documents/nested-knowledge/nk-operations/.venv/lib/python3.
9/site-packages/meltano/cli/__init__.py", line 16, in <module>
    from . import (  # isort:skip # noqa: F401, WPS235
  File "/Users/Documents/nested-knowledge/nk-operations/.venv/lib/python3.
9/site-packages/meltano/cli/schema.py", line 4, in <module>
    import psycopg2

  File "/Users.Documents/nested-knowledge/nk-operations/.venv/lib/python3.
9/site-packages/psycopg2/__init__.py", line 51, in <module>
    from psycopg2._psycopg import (                     # noqa
ImportError: dlopen(/Users/Documents/nested-knowledge/nk-operations/.venv/
lib/python3.9/site-packages/psycopg2/_psycopg.cpython-39-darwin.so, 2): Symbol not f
ound: ____chkstk_darwin
  Referenced from: /Users/Documents/nested-knowledge/nk-operations/.venv/l
ib/python3.9/site-packages/psycopg2/.dylibs/libcrypto.1.1.dylib (which was built for
 Mac OS X 10.15)
  Expected in: /usr/lib/libSystem.B.dylib
 in /Users/Documents/nested-knowledge/nk-operations/.venv/lib/python3.9/si
te-packages/psycopg2/.dylibs/libcrypto.1.1.dylib

On my system, I don’t have any problems installing psycopg2-binary-2.9.3. Does anyone know how to resolve? Any help is appreciated!

I hope you’re not using your MacOS system interpretor .. that being said I can see you’re using Python 3.9 .. I’d back off to 3.8 and follow the pip installation steps outlined in my juju charm which works on ubuntu https://gitlab.com/jrgemcp-public/charms/meltano-charm/-/blob/main/hooks/install#L35-40

try pip install psycopg2-binary It also depends on postgres library I had a lot of grief on Mac M1

pip install psycopg2-binary

produces a similar error. I ended up changing instances of psycopg2-binary to psycopg2 in the source code and then running the following while installing:

poetry remove psycopg2
poetry remove psycopg2-binary
poetry add psycopg2