https://linen.dev logo
Join Slack
Powered by
I am trying to install `tap-redshift` (monad varia...
# troubleshooting
a
I am trying to install 
tap-redshift
(monad variant) but receiving some errors regarding 
psycopg2
, logs in the thread. Is there anything I can do regarding dependencies or might a local fork be needed with some changes? I already have meltano installed with the postgres extra, not sure if that makes a difference
Copy code
2025-11-04T09:16:19,088   Error: pg_config executable not found.

2025-11-04T09:16:19,089   pg_config is required to build psycopg2 from source.  Please add the directory
2025-11-04T09:16:19,089   containing pg_config to the $PATH or specify the full executable path with the
2025-11-04T09:16:19,089   option:

2025-11-04T09:16:19,089       python setup.py build_ext --pg-config /path/to/pg_config build ...

2025-11-04T09:16:19,089   or with the pg_config option in 'setup.cfg'.
Copy code
2025-11-04T09:16:19,150 pip._internal.exceptions.FailedToPrepareCandidate: Failed to build 'psycopg2' when getting requirements to build wheel
2025-11-04T09:16:19,152 Removed psycopg2<3.0.0,>=2.9.3 from <https://files.pythonhosted.org/packages/89/8d/9d12bc8677c24dad342ec777529bce705b3e785fa05d85122b5502b9ab55/psycopg2-2.9.11.tar.gz> (from tap-redshift==1.0.0b9) from build tracker '/tmp/pip-build-tracker-pbm60hos'
2025-11-04T09:16:19,152 Removed build tracker: '/tmp/pip-build-tracker-pbm60hos'
e
can you try adding 
python: python3.10
to the plugin in 
meltano.yml
?
👀 1
a
Copy code
- name: tap-redshift
    variant: monad-inc
    pip_url: git+<https://github.com/Monad-Inc/tap-redshift.git>
    python: python3.10
Same issue I'm afraid, I think I already have py3.10 as my base python.
Same variety of issue with 
datadotworld
variant
sudo apt install postgresql postgresql-contrib libpq-dev python3-dev
sorted it for me I think
@Edgar Ramírez (Arch.dev) I would assume I need a similar command in my Dockerfile if I do this and deploy containerised?
e
Yeah, I just realized they depend on 
psycopo2
and not 
psycopg2-binary
, so you need the C libs in your system to build the Python wheels from source. Not great! FWIW I would love to create a ADBC-based taps and targets, but it's hard to find the time to do so 😅. See https://github.com/columnar-tech/adbc-quickstarts/blob/main/python/redshift/main.py.
30 Views
Open in Slack
PreviousNext
Powered by