Hello, I am trying to run

meltano run tap-postgres target-postgres

and I get:

...
2024-12-20T13:05:34.257693Z [info     ]     import psycopg             cmd_type=elb consumer=True job_name=dev:tap-postgres-to-target-postgres name=target-postgres producer=False run_id=33c3666d-ea4c-4ef2-b595-0f3e73b6d35a stdio=stderr string_id=target-postgres
2024-12-20T13:05:34.258163Z [info     ] ModuleNotFoundError: No module named 'psycopg' cmd_type=elb consumer=True job_name=dev:tap-postgres-to-target-postgres name=target-postgres producer=False run_id=33c3666d-ea4c-4ef2-b595-0f3e73b6d35a stdio=stderr string_id=target-postgres
2024-12-20T13:05:34.333203Z [error    ] Loader failed                 
2024-12-20T13:05:34.333432Z [error    ] Block run completed.           block_type=ExtractLoadBlocks err=RunnerError('Loader failed') exit_codes={<PluginType.LOADERS: 'loaders'>: 1} set_number=0 success=False
Need help fixing this problem? Visit <http://melta.no/> for troubleshooting steps, or to
join our friendly Slack community.

Run invocation could not be completed as block failed: Loader failed

I have tried with both a virtual environment + pip, and pipx

I had an issue similar the other day I think it's Python version. Try using python 3.10 / 3.11 , I think 3.12 doesn't have the wheels or something fyi @Edgar Ramírez (Arch.dev) I didn't dive

I've been using target-postgres on Python 3.12 for a while without any issues actually. FWIW the wheels come from https://pypi.org/project/psycopg-binary, but let me take a look. In the meantime @Luke Riley can you • Tell us about your environment: Operating System, Meltano version (

meltano --version

), Python version • Can you run

meltano install --force

and then try again the command that failed

Thank you both The error went away by installing with

uv

instead of pip I tried both of your suggestions, but on their own (still using pip/pipx) did not work My eventual python version is

3.11.11

, I'm on macos

15.1.1

,

meltano, version 3.6.0

Awesome. I'm tempted to remove the "experimental" warning of the uv installer.