Unable to install with `pip3 install jsonschema2db`

[Miro-Andrin]

I was trying to install this utility but got the following error. Just thought you might want to know. I have tried doing this on my mac (homebrew) and now my linux desktop. My python version is 3.9.7, and pip 21.0.1.

❯ pip3 install jsonschema2db
Defaulting to user installation because normal site-packages is not writeable
Collecting jsonschema2db
  Downloading JSONSchema2DB-1.0.1.tar.gz (9.3 kB)
Collecting change_case==0.5.2
  Downloading change_case-0.5.2.tar.gz (8.6 kB)
Collecting iso8601==0.1.12
  Downloading iso8601-0.1.12-py3-none-any.whl (12 kB)
Collecting psycopg2==2.7.2
  Downloading psycopg2-2.7.2.tar.gz (424 kB)
     |████████████████████████████████| 424 kB 46.8 MB/s 
    ERROR: Command errored out with exit status 1:
     command: /usr/bin/python3 -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-0ew9d1fw/psycopg2_2e085f0049dc4c68b4c6cbd5b4158410/setup.py'"'"'; __file__='"'"'/tmp/pip-install-0ew9d1fw/psycopg2_2e085f0049dc4c68b4c6cbd5b4158410/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base /tmp/pip-pip-egg-info-yaojqdih
         cwd: /tmp/pip-install-0ew9d1fw/psycopg2_2e085f0049dc4c68b4c6cbd5b4158410/
    Complete output (14 lines):
    running egg_info
    creating /tmp/pip-pip-egg-info-yaojqdih/psycopg2.egg-info
    writing /tmp/pip-pip-egg-info-yaojqdih/psycopg2.egg-info/PKG-INFO
    writing dependency_links to /tmp/pip-pip-egg-info-yaojqdih/psycopg2.egg-info/dependency_links.txt
    writing top-level names to /tmp/pip-pip-egg-info-yaojqdih/psycopg2.egg-info/top_level.txt
    writing manifest file '/tmp/pip-pip-egg-info-yaojqdih/psycopg2.egg-info/SOURCES.txt'
    Error: pg_config executable not found.
    
    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'.
    ----------------------------------------
WARNING: Discarding https://files.pythonhosted.org/packages/d0/66/61c1b34ea8da8f95d99676e6803ccad83abef3ac90df145b45033696f3d2/psycopg2-2.7.2.tar.gz#sha256=3767f40bb35713ccc75dbcff80bf228a75e080d6b98c78afd5fb9aa84682a9f4 (from https://pypi.org/simple/psycopg2/). Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.
Collecting jsonschema2db
  Downloading JSONSchema2DB-1.0.0.tar.gz (9.3 kB)
ERROR: Cannot install jsonschema2db==1.0.0 and jsonschema2db==1.0.1 because these package versions have conflicting dependencies.

The conflict is caused by:
    jsonschema2db 1.0.1 depends on psycopg2==2.7.2
    jsonschema2db 1.0.0 depends on psycopg2==2.7.2

To fix this you could try to:
1. loosen the range of package versions you've specified
2. remove package versions to allow pip attempt to solve the dependency conflict

ERROR: ResolutionImpossible: for help visit https://pip.pypa.io/en/latest/user_guide/#fixing-conflicting-dependencies

[erikbern]

This looks like a problem with psycopg2, not jsonschema2db?

[cabljac]

I believe i got a similar issue, i think some package was renamed - the psycopg2 package was changed to psycopg2-binary

I created a PR with what i remember fixed it - https://github.com/better/jsonschema2db/pull/46

[arnespremberg]

Will this be merged anytime soon?