Hi meltano gurus, I am having again issues with po...
# troubleshooting
i
Hi meltano gurus, I am having again issues with postgres/redshift targets on Mac M1. Using latest 0.96.0 I think they are related to psycopg2 driver for pg. Is there any way to install target without separate venv? Trying to hack this manually... I am already in venv in which "import psycopg2" - but taget is different venv Here is the error:
Copy code
022-03-03T02:20:54.601941Z [info     ] ImportError: dlopen(/Users/ivo/gitlab/meltano-elt-poc/gs/.meltano/loaders/target-redshift/venv/lib/python3.9/site-packages/psycopg2/_psycopg.cpython-39-darwin.so, 0x0002):
tried: '/Users/ivo/gitlab/meltano-elt-poc/gs/.meltano/loaders/target-redshift/venv/lib/python3.9/site-packages/psycopg2/_psycopg.cpython-39-darwin.so' (mach-o file, but is an incompatible architecture
(have 'x86_64', need 'arm64e')),
'/usr/local/lib/_psycopg.cpython-39-darwin.so' (no such file),
'/usr/lib/_psycopg.cpython-39-darwin.so' (no such file) cmd_type=loader job_id=2022-03-03T022052--tap-google-sheets--target-redshift name=target-redshift run_id=83847ae4-928d-4be1-8299-a12806d0a845 stdio=stderr
I spent a lot of time trying to build psycopg2 for arm64 - the only success was with x86 but 'meltano add target-redshift' creates arm64 venv. basically I want to pip install the target - is it possible?