v2.5 issues airflow Hey team 😄 I just tried to upgrade to v2.5 of meltano, and am getting this airflow error when trying to build:

error: subprocess-exited-with-error
  
  × python setup.py egg_info did not run successfully.
  │ exit code: 1
  ╰─> [23 lines of output]
      running egg_info
      creating /tmp/pip-pip-egg-info-7syx226q/psycopg2.egg-info
      writing /tmp/pip-pip-egg-info-7syx226q/psycopg2.egg-info/PKG-INFO
      writing dependency_links to /tmp/pip-pip-egg-info-7syx226q/psycopg2.egg-info/dependency_links.txt
      writing top-level names to /tmp/pip-pip-egg-info-7syx226q/psycopg2.egg-info/top_level.txt
      writing manifest file '/tmp/pip-pip-egg-info-7syx226q/psycopg2.egg-info/SOURCES.txt'
      
      Error: pg_config executable not found.
      
      pg_config is required to build psycopg2 from source.  Please add the directory
      containing pg_config to the $PATH or specify the full executable path with the
      option:
      
          python setup.py build_ext --pg-config /path/to/pg_config build ...
      
      or with the pg_config option in 'setup.cfg'.
      
      If you prefer to avoid building psycopg2 from source, please install the PyPI
      'psycopg2-binary' package instead.
      
      For further information please check the 'doc/src/install.rst' file (also at
      <<https://www.psycopg.org/docs/install.html>>).
      
      [end of output]
  
  note: This error originates from a subprocess, and is likely not a problem with pip.
error: metadata-generation-failed

× Encountered error while generating package metadata.
╰─> See above for output.

note: This is an issue with the package mentioned above, not pip.
hint: See above for details.

Any thoughts?

You'll need to either install

libpq-dev

(a system package, not a Python package), or update the dependencies of the package you're trying to install to use the

psycopg2-binary

Python package instead of

psycopg2

.

This means, if I'm running in docker, I'd need to install libpq-dev, I would need to run `

sudo apt-get -y install libpq-dev

in my container?

Yes.

Would I have to run this command everytime, or only once?

libpq-dev

needs to be installed on the system where you want to use the

psycopg2

Python package. Putting the command in your

Dockerfile

should work.

Ok awesome, thanks!

Do you know which tap/target you're using is depending on

psycopg2

instead of

psycopg2-binary

? It'd be good for us to update it to use

psycopg2-binary

.

Ah wait I may have my answer, I had psycopg2 (and not the bin) in my path