anxolerd / dvpwa

Damn Vulnerable Python Web App
MIT License
159 stars 526 forks source link

Installation not working? #19

Open rohitcoder opened 1 year ago

rohitcoder commented 1 year ago

Hi @anxolerd ,

I was trying to setup this project locally with pip3 install -r requirements.txt. I'm getting below error

(venv) rohitcoder@Rohits-MacBook-Pro dvpwa % pip install -r requirements.txt
Collecting aiohttp-jinja2==1.1.0
  Using cached aiohttp_jinja2-1.1.0-py3-none-any.whl (10 kB)
Collecting aiohttp-session==2.7.0
  Using cached aiohttp_session-2.7.0-py3-none-any.whl (14 kB)
Collecting aiohttp==3.5.3
  Using cached aiohttp-3.5.3-py3-none-any.whl
Collecting aiopg==0.15.0
  Using cached aiopg-0.15.0-py3-none-any.whl (31 kB)
Collecting aioredis==1.2.0
  Using cached aioredis-1.2.0-py3-none-any.whl (63 kB)
Collecting async-timeout==3.0.1
  Using cached async_timeout-3.0.1-py3-none-any.whl (8.2 kB)
Collecting attrs==18.2.0
  Using cached attrs-18.2.0-py2.py3-none-any.whl (34 kB)
Collecting chardet==3.0.4
  Using cached chardet-3.0.4-py2.py3-none-any.whl (133 kB)
Collecting hiredis==0.3.1
  Using cached hiredis-0.3.1-cp310-cp310-macosx_13_0_arm64.whl
Collecting idna==2.8
  Using cached idna-2.8-py2.py3-none-any.whl (58 kB)
Collecting jinja2==2.10
  Using cached Jinja2-2.10-py2.py3-none-any.whl (126 kB)
Collecting markupsafe==1.1.0
  Using cached MarkupSafe-1.1.0-cp310-cp310-macosx_13_0_arm64.whl
Collecting multidict==4.5.2
  Using cached multidict-4.5.2-py3-none-any.whl
Collecting psycopg2==2.7.6.1
  Using cached psycopg2-2.7.6.1.tar.gz (427 kB)
  Preparing metadata (setup.py) ... done
Requirement already satisfied: pyyaml==3.13 in ./venv/lib/python3.10/site-packages (from -r requirements.txt (line 15)) (3.13)
Collecting trafaret-config==2.0.2
  Using cached trafaret_config-2.0.2-py3-none-any.whl
Requirement already satisfied: trafaret==1.2.0 in ./venv/lib/python3.10/site-packages (from -r requirements.txt (line 17)) (1.2.0)
Collecting yarl==1.3.0
  Using cached yarl-1.3.0-py3-none-any.whl
Installing collected packages: psycopg2, chardet, attrs, trafaret-config, multidict, markupsafe, idna, hiredis, async-timeout, aiopg, yarl, jinja2, aioredis, aiohttp, aiohttp-session, aiohttp-jinja2
  DEPRECATION: psycopg2 is being installed using the legacy 'setup.py install' method, because it does not have a 'pyproject.toml' and the 'wheel' package is not installed. pip 23.1 will enforce this behaviour change. A possible replacement is to enable the '--use-pep517' option. Discussion can be found at https://github.com/pypa/pip/issues/8559
  Running setup.py install for psycopg2 ... error
  error: subprocess-exited-with-error

  × Running setup.py install for psycopg2 did not run successfully.
  │ exit code: 1
  ╰─> [141 lines of output]
      /Users/rohitcoder/Desktop/dvpwa/venv/lib/python3.10/site-packages/setuptools/config/setupcfg.py:508: SetuptoolsDeprecationWarning: The license_file parameter is deprecated, use license_files instead.
        warnings.warn(msg, warning_class)
      running install
      /Users/rohitcoder/Desktop/dvpwa/venv/lib/python3.10/site-packages/setuptools/command/install.py:34: SetuptoolsDeprecationWarning: setup.py install is deprecated. Use build and pip and other standards-based tools.
        warnings.warn(
      running build
      running build_py
      creating build
      creating build/lib.macosx-13-arm64-cpython-310
      creating build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/_json.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/extras.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/errorcodes.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/tz.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/_range.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/_ipaddress.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/__init__.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/psycopg1.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/extensions.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/sql.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/pool.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      creating build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_transaction.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/dbapi20.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_extras_dictcursor.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_with.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_types_basic.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_bug_gc.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_module.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_psycopg2_dbapi20.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_async.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_dates.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_async_keyword.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/testutils.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_connection.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_copy.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_bugX000.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/__init__.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_cursor.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_types_extras.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_sql.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_fast_executemany.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_green.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_ipaddress.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_cancel.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_quote.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/testconfig.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_errcodes.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_replication.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_lobject.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_notify.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/dbapi20_tpc.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      running build_ext
      building 'psycopg2._psycopg' extension
      creating build/temp.macosx-13-arm64-cpython-310
      creating build/temp.macosx-13-arm64-cpython-310/psycopg
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_asis.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_asis.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_binary.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_binary.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_datetime.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_datetime.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_list.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_list.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_pboolean.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_pboolean.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_pdecimal.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_pdecimal.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_pfloat.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_pfloat.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_pint.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_pint.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_qstring.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_qstring.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/bytes_format.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/bytes_format.o
      In file included from psycopg/bytes_format.c:81:
      In file included from ./psycopg/psycopg.h:37:
      ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
      static void Dprintf(const char *fmt, ...) {}
                  ^
      1 warning generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/connection_int.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/connection_int.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/connection_type.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/connection_type.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/cursor_int.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/cursor_int.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/cursor_type.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/cursor_type.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/diagnostics_type.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/diagnostics_type.o
      In file included from psycopg/diagnostics_type.c:27:
      In file included from ./psycopg/psycopg.h:37:
      ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
      static void Dprintf(const char *fmt, ...) {}
                  ^
      1 warning generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/error_type.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/error_type.o
      In file included from psycopg/error_type.c:27:
      In file included from ./psycopg/psycopg.h:37:
      ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
      static void Dprintf(const char *fmt, ...) {}
                  ^
      1 warning generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/green.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/green.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/libpq_support.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/libpq_support.o
      In file included from psycopg/libpq_support.c:29:
      In file included from ./psycopg/psycopg.h:37:
      ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
      static void Dprintf(const char *fmt, ...) {}
                  ^
      1 warning generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/lobject_int.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/lobject_int.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/lobject_type.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/lobject_type.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/microprotocols.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/microprotocols.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/microprotocols_proto.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/microprotocols_proto.o
      In file included from psycopg/microprotocols_proto.c:27:
      In file included from ./psycopg/psycopg.h:37:
      ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
      static void Dprintf(const char *fmt, ...) {}
                  ^
      1 warning generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/notify_type.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/notify_type.o
      In file included from psycopg/notify_type.c:27:
      In file included from ./psycopg/psycopg.h:37:
      ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
      static void Dprintf(const char *fmt, ...) {}
                  ^
      1 warning generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/pqpath.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/pqpath.o
      psycopg/pqpath.c:214:17: warning: implicit conversion from enumeration type 'ConnStatusType' to different enumeration type 'ExecStatusType' [-Wenum-conversion]
                      PQstatus(conn->pgconn) : PQresultStatus(*pgres)));
                      ^~~~~~~~~~~~~~~~~~~~~~
      psycopg/pqpath.c:1871:11: warning: code will never be executed [-Wunreachable-code]
          ret = 1;
                ^
      psycopg/pqpath.c:1990:17: warning: implicit conversion from enumeration type 'ConnStatusType' to different enumeration type 'ExecStatusType' [-Wenum-conversion]
                      PQstatus(curs->conn->pgconn) : PQresultStatus(curs->pgres)));
                      ^~~~~~~~~~~~~~~~~~~~~~~~~~~~
      3 warnings generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/psycopgmodule.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/psycopgmodule.o
      psycopg/psycopgmodule.c:689:18: error: incomplete definition of type 'struct _is'
          while (interp->next)
                 ~~~~~~^
      /opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10/pystate.h:17:8: note: forward declaration of 'struct _is'
      struct _is;
             ^
      psycopg/psycopgmodule.c:690:24: error: incomplete definition of type 'struct _is'
              interp = interp->next;
                       ~~~~~~^
      /opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10/pystate.h:17:8: note: forward declaration of 'struct _is'
      struct _is;
             ^
      2 errors generated.
      error: command '/usr/bin/clang' failed with exit code 1
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
error: legacy-install-failure

× Encountered error while trying to install package.
╰─> psycopg2

note: This is an issue with the package mentioned above, not pip.
hint: See above for output from the failure.
(venv) rohitcoder@Rohits-MacBook-Pro dvpwa % 

I did some research and found, we can use --use-pep517 flag and this may solve issue, i was following https://github.com/pypa/pip/issues/8559 but still it's giving me below error

(venv) rohitcoder@Rohits-MacBook-Pro dvpwa % pip install -r requirements.txt --use-pep517
Collecting aiohttp-jinja2==1.1.0
  Using cached aiohttp_jinja2-1.1.0-py3-none-any.whl (10 kB)
Collecting aiohttp-session==2.7.0
  Using cached aiohttp_session-2.7.0-py3-none-any.whl (14 kB)
Collecting aiohttp==3.5.3
  Using cached aiohttp-3.5.3-py3-none-any.whl
Collecting aiopg==0.15.0
  Using cached aiopg-0.15.0-py3-none-any.whl (31 kB)
Collecting aioredis==1.2.0
  Using cached aioredis-1.2.0-py3-none-any.whl (63 kB)
Collecting async-timeout==3.0.1
  Using cached async_timeout-3.0.1-py3-none-any.whl (8.2 kB)
Collecting attrs==18.2.0
  Using cached attrs-18.2.0-py2.py3-none-any.whl (34 kB)
Collecting chardet==3.0.4
  Using cached chardet-3.0.4-py2.py3-none-any.whl (133 kB)
Collecting hiredis==0.3.1
  Using cached hiredis-0.3.1-cp310-cp310-macosx_13_0_arm64.whl
Collecting idna==2.8
  Using cached idna-2.8-py2.py3-none-any.whl (58 kB)
Collecting jinja2==2.10
  Using cached Jinja2-2.10-py2.py3-none-any.whl (126 kB)
Collecting markupsafe==1.1.0
  Using cached MarkupSafe-1.1.0-cp310-cp310-macosx_13_0_arm64.whl
Collecting multidict==4.5.2
  Using cached multidict-4.5.2-py3-none-any.whl
Collecting psycopg2==2.7.6.1
  Using cached psycopg2-2.7.6.1.tar.gz (427 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
Requirement already satisfied: pyyaml==3.13 in ./venv/lib/python3.10/site-packages (from -r requirements.txt (line 15)) (3.13)
Collecting trafaret-config==2.0.2
  Using cached trafaret_config-2.0.2-py3-none-any.whl
Requirement already satisfied: trafaret==1.2.0 in ./venv/lib/python3.10/site-packages (from -r requirements.txt (line 17)) (1.2.0)
Collecting yarl==1.3.0
  Using cached yarl-1.3.0-py3-none-any.whl
Building wheels for collected packages: psycopg2
  Building wheel for psycopg2 (pyproject.toml) ... error
  error: subprocess-exited-with-error

  × Building wheel for psycopg2 (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [139 lines of output]
      /private/var/folders/d5/ln34v0y963b1zvpp9vzjmcpr0000gn/T/pip-build-env-gz358qqc/overlay/lib/python3.10/site-packages/setuptools/config/setupcfg.py:508: SetuptoolsDeprecationWarning: The license_file parameter is deprecated, use license_files instead.
        warnings.warn(msg, warning_class)
      running bdist_wheel
      running build
      running build_py
      creating build
      creating build/lib.macosx-13-arm64-cpython-310
      creating build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/_json.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/extras.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/errorcodes.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/tz.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/_range.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/_ipaddress.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/__init__.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/psycopg1.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/extensions.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/sql.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      copying lib/pool.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2
      creating build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_transaction.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/dbapi20.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_extras_dictcursor.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_with.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_types_basic.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_bug_gc.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_module.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_psycopg2_dbapi20.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_async.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_dates.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_async_keyword.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/testutils.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_connection.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_copy.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_bugX000.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/__init__.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_cursor.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_types_extras.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_sql.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_fast_executemany.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_green.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_ipaddress.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_cancel.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_quote.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/testconfig.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_errcodes.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_replication.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_lobject.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/test_notify.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      copying tests/dbapi20_tpc.py -> build/lib.macosx-13-arm64-cpython-310/psycopg2/tests
      running build_ext
      building 'psycopg2._psycopg' extension
      creating build/temp.macosx-13-arm64-cpython-310
      creating build/temp.macosx-13-arm64-cpython-310/psycopg
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_asis.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_asis.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_binary.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_binary.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_datetime.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_datetime.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_list.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_list.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_pboolean.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_pboolean.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_pdecimal.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_pdecimal.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_pfloat.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_pfloat.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_pint.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_pint.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/adapter_qstring.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/adapter_qstring.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/bytes_format.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/bytes_format.o
      In file included from psycopg/bytes_format.c:81:
      In file included from ./psycopg/psycopg.h:37:
      ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
      static void Dprintf(const char *fmt, ...) {}
                  ^
      1 warning generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/connection_int.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/connection_int.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/connection_type.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/connection_type.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/cursor_int.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/cursor_int.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/cursor_type.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/cursor_type.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/diagnostics_type.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/diagnostics_type.o
      In file included from psycopg/diagnostics_type.c:27:
      In file included from ./psycopg/psycopg.h:37:
      ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
      static void Dprintf(const char *fmt, ...) {}
                  ^
      1 warning generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/error_type.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/error_type.o
      In file included from psycopg/error_type.c:27:
      In file included from ./psycopg/psycopg.h:37:
      ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
      static void Dprintf(const char *fmt, ...) {}
                  ^
      1 warning generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/green.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/green.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/libpq_support.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/libpq_support.o
      In file included from psycopg/libpq_support.c:29:
      In file included from ./psycopg/psycopg.h:37:
      ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
      static void Dprintf(const char *fmt, ...) {}
                  ^
      1 warning generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/lobject_int.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/lobject_int.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/lobject_type.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/lobject_type.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/microprotocols.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/microprotocols.o
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/microprotocols_proto.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/microprotocols_proto.o
      In file included from psycopg/microprotocols_proto.c:27:
      In file included from ./psycopg/psycopg.h:37:
      ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
      static void Dprintf(const char *fmt, ...) {}
                  ^
      1 warning generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/notify_type.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/notify_type.o
      In file included from psycopg/notify_type.c:27:
      In file included from ./psycopg/psycopg.h:37:
      ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
      static void Dprintf(const char *fmt, ...) {}
                  ^
      1 warning generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/pqpath.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/pqpath.o
      psycopg/pqpath.c:214:17: warning: implicit conversion from enumeration type 'ConnStatusType' to different enumeration type 'ExecStatusType' [-Wenum-conversion]
                      PQstatus(conn->pgconn) : PQresultStatus(*pgres)));
                      ^~~~~~~~~~~~~~~~~~~~~~
      psycopg/pqpath.c:1871:11: warning: code will never be executed [-Wunreachable-code]
          ret = 1;
                ^
      psycopg/pqpath.c:1990:17: warning: implicit conversion from enumeration type 'ConnStatusType' to different enumeration type 'ExecStatusType' [-Wenum-conversion]
                      PQstatus(curs->conn->pgconn) : PQresultStatus(curs->pgres)));
                      ^~~~~~~~~~~~~~~~~~~~~~~~~~~~
      3 warnings generated.
      clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=2.7.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=140002 -DHAVE_LO64=1 -I/Users/rohitcoder/Desktop/dvpwa/venv/include -I/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10 -I. -I/Applications/Postgres.app/Contents/Versions/14/include -I/Applications/Postgres.app/Contents/Versions/14/include/postgresql/server -c psycopg/psycopgmodule.c -o build/temp.macosx-13-arm64-cpython-310/psycopg/psycopgmodule.o
      psycopg/psycopgmodule.c:689:18: error: incomplete definition of type 'struct _is'
          while (interp->next)
                 ~~~~~~^
      /opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10/pystate.h:17:8: note: forward declaration of 'struct _is'
      struct _is;
             ^
      psycopg/psycopgmodule.c:690:24: error: incomplete definition of type 'struct _is'
              interp = interp->next;
                       ~~~~~~^
      /opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/include/python3.10/pystate.h:17:8: note: forward declaration of 'struct _is'
      struct _is;
             ^
      2 errors generated.
      error: command '/usr/bin/clang' failed with exit code 1
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
  ERROR: Failed building wheel for psycopg2
Failed to build psycopg2
ERROR: Could not build wheels for psycopg2, which is required to install pyproject.toml-based projects

Any workaround or solution for this @anxolerd ? I'm using Mac M1 & it's a python3 environment

rohitcoder@Rohits-MacBook-Pro ~ % python3 --version
Python 3.10.9
rohitcoder@Rohits-MacBook-Pro ~ % pip3 --version                              
pip 22.3.1 from /opt/homebrew/lib/python3.10/site-packages/pip (python 3.10)
0xdarkfloyd commented 1 year ago

I changed it to the latest version: Collecting psycopg2==2.9.5, it works, and see whether it applies in your case.

anxolerd commented 1 year ago

Thanks for the report. I believe, I can safely migrate this to psycopg2-binary to avoid building postgres driver from source and thus having such issue.