Hey team! At some point of time I’ve started to see the following message during `meltano --log-level=debug run/invoke`:

Creating DB engine for project at '' with DB URI 'postgresql+psycopg://

couldn't import psycopg 'c' implementation: No module named 'psycopg_c'

. I’ve reinstalled meltano using

pipx install "meltano[postgres]"

, but it doesn’t help.

psycopg_binary

seems to be installed in meltano’s pipx env dir. Am I missing something?

Hi Denis! What version of Python and OS are you running Meltano on?

Mac OS Sonoma 14.1.1, python 3.11.6 (pyenv shims) Looks like it’s started to happen after pipx bumped default python version to 3.12 which broke Meltano update with pipx and I updated Meltano with pipx forced to use python 3.11.

Ok, so the issue is resolved by forcing Meltano to be installed in Python 3.11? (I'm planning to release support for Python 3.12 in the coming weeks, and I do see that psycopg-binary does have wheels for 3.12 so I wonder what could be the problem)

Yeah, you’re right, it’s just a logging message that pop up when debug level enabled. Initially the issue was with python 3.12 forced by pipx by default, which made Meltano unable to install/update in my env. I pined pipx to 3.11 and at some point of time afterwards I ran a custom tap in debug mode to fix some other issues and saw this log message, but it appeared not related at all (: I’m not sure if the log message was (or wasn’t) presented before. @edgar_ramirez_mondragon than you!