Issue upgrading from v3.7.8 to v4.0.7 with psycopg-c RHEL8

[scu-cmoore1]

We upgraded successfully from v3.5.7 to v3.7.8, but when attempting to run an upgrade on v4.0.7, we got an error related to psycopg. Is there an additional package that needs to be installed for RHEL8? We already have libpq-devel and python3.11-devel installed as suggested in this issue #16047

Error output on running upgrade.sh

[netbox@netbox-rh8v netbox]# PYTHON=/usr/bin/python3.11 ./upgrade.sh
You are installing (or upgrading to) NetBox version 4.0.0
Using Python 3.11.5
Removing old virtual environment...
Creating a new virtual environment at /opt/netbox/venv...
Updating pip (pip install --upgrade pip)...
Requirement already satisfied: pip in ./venv/lib64/python3.11/site-packages (22.3.1)
Collecting pip
  Using cached pip-24.1.2-py3-none-any.whl (1.8 MB)
Installing collected packages: pip
  Attempting uninstall: pip
    Found existing installation: pip 22.3.1
    Uninstalling pip-22.3.1:
      Successfully uninstalled pip-22.3.1
Successfully installed pip-24.1.2
pip 24.1.2 from /opt/netbox/venv/lib64/python3.11/site-packages/pip (python 3.11)
Installing Python system packages (pip install wheel)...
Collecting wheel
  Using cached wheel-0.43.0-py3-none-any.whl.metadata (2.2 kB)
Using cached wheel-0.43.0-py3-none-any.whl (65 kB)
Installing collected packages: wheel
Successfully installed wheel-0.43.0
Installing core dependencies (pip install -r requirements.txt)...
Collecting Django==5.0.5 (from -r requirements.txt (line 1))
  Using cached Django-5.0.5-py3-none-any.whl.metadata (4.2 kB)
Collecting django-cors-headers==4.3.1 (from -r requirements.txt (line 2))
  Using cached django_cors_headers-4.3.1-py3-none-any.whl.metadata (16 kB)
Collecting django-debug-toolbar==4.3.0 (from -r requirements.txt (line 3))
  Using cached django_debug_toolbar-4.3.0-py3-none-any.whl.metadata (4.0 kB)
Collecting django-filter==24.2 (from -r requirements.txt (line 4))
  Using cached django_filter-24.2-py3-none-any.whl.metadata (5.1 kB)
Collecting django-htmx==1.17.3 (from -r requirements.txt (line 5))
  Using cached django_htmx-1.17.3-py3-none-any.whl.metadata (2.7 kB)
Collecting django-graphiql-debug-toolbar==0.2.0 (from -r requirements.txt (line 6))
  Using cached django_graphiql_debug_toolbar-0.2.0-py3-none-any.whl.metadata (3.5 kB)
Collecting django-mptt==0.16.0 (from -r requirements.txt (line 7))
  Using cached django_mptt-0.16.0-py3-none-any.whl.metadata (5.2 kB)
Collecting django-pglocks==1.0.4 (from -r requirements.txt (line 8))
  Using cached django_pglocks-1.0.4-py3-none-any.whl
Collecting django-prometheus==2.3.1 (from -r requirements.txt (line 9))
  Using cached django_prometheus-2.3.1-py2.py3-none-any.whl.metadata (9.4 kB)
Collecting django-redis==5.4.0 (from -r requirements.txt (line 10))
  Using cached django_redis-5.4.0-py3-none-any.whl.metadata (32 kB)
Collecting django-rich==1.8.0 (from -r requirements.txt (line 11))
  Using cached django_rich-1.8.0-py3-none-any.whl.metadata (6.8 kB)
Collecting django-rq==2.10.2 (from -r requirements.txt (line 12))
  Using cached django_rq-2.10.2-py2.py3-none-any.whl.metadata (18 kB)
Collecting django-taggit==5.0.1 (from -r requirements.txt (line 13))
  Using cached django_taggit-5.0.1-py3-none-any.whl.metadata (3.4 kB)
Collecting django-tables2==2.7.0 (from -r requirements.txt (line 14))
  Using cached django_tables2-2.7.0-py2.py3-none-any.whl.metadata (3.9 kB)
Collecting django-timezone-field==6.1.0 (from -r requirements.txt (line 15))
  Using cached django_timezone_field-6.1.0-py3-none-any.whl.metadata (12 kB)
Collecting djangorestframework==3.15.1 (from -r requirements.txt (line 16))
  Using cached djangorestframework-3.15.1-py3-none-any.whl.metadata (11 kB)
Collecting drf-spectacular==0.27.2 (from -r requirements.txt (line 17))
  Using cached drf_spectacular-0.27.2-py3-none-any.whl.metadata (14 kB)
Collecting drf-spectacular-sidecar==2024.5.1 (from -r requirements.txt (line 18))
  Using cached drf_spectacular_sidecar-2024.5.1-py3-none-any.whl.metadata (3.4 kB)
Collecting feedparser==6.0.11 (from -r requirements.txt (line 19))
  Using cached feedparser-6.0.11-py3-none-any.whl.metadata (2.4 kB)
Collecting gunicorn==22.0.0 (from -r requirements.txt (line 20))
  Using cached gunicorn-22.0.0-py3-none-any.whl.metadata (4.4 kB)
Collecting Jinja2==3.1.4 (from -r requirements.txt (line 21))
  Using cached jinja2-3.1.4-py3-none-any.whl.metadata (2.6 kB)
Collecting Markdown==3.6 (from -r requirements.txt (line 22))
  Using cached Markdown-3.6-py3-none-any.whl.metadata (7.0 kB)
Collecting mkdocs-material==9.5.21 (from -r requirements.txt (line 23))
  Using cached mkdocs_material-9.5.21-py3-none-any.whl.metadata (17 kB)
Collecting mkdocstrings==0.25.1 (from mkdocstrings[python-legacy]==0.25.1->-r requirements.txt (line 24))
  Using cached mkdocstrings-0.25.1-py3-none-any.whl.metadata (7.6 kB)
Collecting netaddr==1.2.1 (from -r requirements.txt (line 25))
  Using cached netaddr-1.2.1-py3-none-any.whl.metadata (5.0 kB)
Collecting nh3==0.2.17 (from -r requirements.txt (line 26))
  Using cached nh3-0.2.17-cp37-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.metadata (1.7 kB)
Collecting Pillow==10.3.0 (from -r requirements.txt (line 27))
  Using cached pillow-10.3.0-cp311-cp311-manylinux_2_28_x86_64.whl.metadata (9.2 kB)
Collecting psycopg==3.1.18 (from psycopg[c,pool]==3.1.18->-r requirements.txt (line 28))
  Using cached psycopg-3.1.18-py3-none-any.whl.metadata (4.2 kB)
Collecting PyYAML==6.0.1 (from -r requirements.txt (line 29))
  Using cached PyYAML-6.0.1-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.metadata (2.1 kB)
Collecting requests==2.31.0 (from -r requirements.txt (line 30))
  Using cached requests-2.31.0-py3-none-any.whl.metadata (4.6 kB)
Collecting social-auth-app-django==5.4.1 (from -r requirements.txt (line 31))
  Using cached social_auth_app_django-5.4.1-py3-none-any.whl.metadata (3.2 kB)
Collecting social-auth-core==4.5.4 (from -r requirements.txt (line 32))
  Using cached social_auth_core-4.5.4-py3-none-any.whl.metadata (4.1 kB)
Collecting strawberry-graphql==0.227.3 (from -r requirements.txt (line 33))
  Using cached strawberry_graphql-0.227.3-py3-none-any.whl.metadata (7.8 kB)
Collecting strawberry-graphql-django==0.39.2 (from -r requirements.txt (line 34))
  Using cached strawberry_graphql_django-0.39.2-py3-none-any.whl.metadata (5.0 kB)
Collecting svgwrite==1.4.3 (from -r requirements.txt (line 35))
  Using cached svgwrite-1.4.3-py3-none-any.whl.metadata (8.8 kB)
Collecting tablib==3.6.1 (from -r requirements.txt (line 36))
  Using cached tablib-3.6.1-py3-none-any.whl.metadata (3.8 kB)
Collecting tzdata==2024.1 (from -r requirements.txt (line 37))
  Using cached tzdata-2024.1-py2.py3-none-any.whl.metadata (1.4 kB)
Collecting asgiref<4,>=3.7.0 (from Django==5.0.5->-r requirements.txt (line 1))
  Using cached asgiref-3.8.1-py3-none-any.whl.metadata (9.3 kB)
Collecting sqlparse>=0.3.1 (from Django==5.0.5->-r requirements.txt (line 1))
  Using cached sqlparse-0.5.1-py3-none-any.whl.metadata (3.9 kB)
Collecting graphene-django>=2.0.0 (from django-graphiql-debug-toolbar==0.2.0->-r requirements.txt (line 6))
  Using cached graphene_django-3.2.2-py2.py3-none-any.whl.metadata (8.3 kB)
Collecting django-js-asset (from django-mptt==0.16.0->-r requirements.txt (line 7))
  Using cached django_js_asset-2.2.0-py3-none-any.whl.metadata (3.5 kB)
Collecting six>=1.0.0 (from django-pglocks==1.0.4->-r requirements.txt (line 8))
  Using cached six-1.16.0-py2.py3-none-any.whl.metadata (1.8 kB)
Collecting prometheus-client>=0.7 (from django-prometheus==2.3.1->-r requirements.txt (line 9))
  Using cached prometheus_client-0.20.0-py3-none-any.whl.metadata (1.8 kB)
Collecting redis!=4.0.0,!=4.0.1,>=3 (from django-redis==5.4.0->-r requirements.txt (line 10))
  Using cached redis-5.0.7-py3-none-any.whl.metadata (9.3 kB)
Collecting rich>=10.0.0 (from django-rich==1.8.0->-r requirements.txt (line 11))
  Using cached rich-13.7.1-py3-none-any.whl.metadata (18 kB)
Collecting rq>=1.14 (from django-rq==2.10.2->-r requirements.txt (line 12))
  Using cached rq-1.16.2-py3-none-any.whl.metadata (5.7 kB)
Collecting uritemplate>=2.0.0 (from drf-spectacular==0.27.2->-r requirements.txt (line 17))
  Using cached uritemplate-4.1.1-py2.py3-none-any.whl.metadata (2.9 kB)
Collecting jsonschema>=2.6.0 (from drf-spectacular==0.27.2->-r requirements.txt (line 17))
  Using cached jsonschema-4.23.0-py3-none-any.whl.metadata (7.9 kB)
Collecting inflection>=0.3.1 (from drf-spectacular==0.27.2->-r requirements.txt (line 17))
  Using cached inflection-0.5.1-py2.py3-none-any.whl.metadata (1.7 kB)
Collecting sgmllib3k (from feedparser==6.0.11->-r requirements.txt (line 19))
  Using cached sgmllib3k-1.0.0-py3-none-any.whl
Collecting packaging (from gunicorn==22.0.0->-r requirements.txt (line 20))
  Using cached packaging-24.1-py3-none-any.whl.metadata (3.2 kB)
Collecting MarkupSafe>=2.0 (from Jinja2==3.1.4->-r requirements.txt (line 21))
  Using cached MarkupSafe-2.1.5-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.metadata (3.0 kB)
Collecting babel~=2.10 (from mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached Babel-2.15.0-py3-none-any.whl.metadata (1.5 kB)
Collecting colorama~=0.4 (from mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached colorama-0.4.6-py2.py3-none-any.whl.metadata (17 kB)
Collecting mkdocs-material-extensions~=1.3 (from mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached mkdocs_material_extensions-1.3.1-py3-none-any.whl.metadata (6.9 kB)
Collecting mkdocs~=1.6 (from mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached mkdocs-1.6.0-py3-none-any.whl.metadata (6.0 kB)
Collecting paginate~=0.5 (from mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached paginate-0.5.6-py3-none-any.whl
Collecting pygments~=2.16 (from mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached pygments-2.18.0-py3-none-any.whl.metadata (2.5 kB)
Collecting pymdown-extensions~=10.2 (from mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached pymdown_extensions-10.8.1-py3-none-any.whl.metadata (3.0 kB)
Collecting regex>=2022.4 (from mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached regex-2024.5.15-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.metadata (40 kB)
Collecting click>=7.0 (from mkdocstrings==0.25.1->mkdocstrings[python-legacy]==0.25.1->-r requirements.txt (line 24))
  Using cached click-8.1.7-py3-none-any.whl.metadata (3.0 kB)
Collecting mkdocs-autorefs>=0.3.1 (from mkdocstrings==0.25.1->mkdocstrings[python-legacy]==0.25.1->-r requirements.txt (line 24))
  Using cached mkdocs_autorefs-1.0.1-py3-none-any.whl.metadata (6.9 kB)
Collecting platformdirs>=2.2.0 (from mkdocstrings==0.25.1->mkdocstrings[python-legacy]==0.25.1->-r requirements.txt (line 24))
  Using cached platformdirs-4.2.2-py3-none-any.whl.metadata (11 kB)
Collecting typing-extensions>=4.1 (from psycopg==3.1.18->psycopg[c,pool]==3.1.18->-r requirements.txt (line 28))
  Using cached typing_extensions-4.12.2-py3-none-any.whl.metadata (3.0 kB)
Collecting charset-normalizer<4,>=2 (from requests==2.31.0->-r requirements.txt (line 30))
  Using cached charset_normalizer-3.3.2-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.metadata (33 kB)
Collecting idna<4,>=2.5 (from requests==2.31.0->-r requirements.txt (line 30))
  Using cached idna-3.7-py3-none-any.whl.metadata (9.9 kB)
Collecting urllib3<3,>=1.21.1 (from requests==2.31.0->-r requirements.txt (line 30))
  Using cached urllib3-2.2.2-py3-none-any.whl.metadata (6.4 kB)
Collecting certifi>=2017.4.17 (from requests==2.31.0->-r requirements.txt (line 30))
  Using cached certifi-2024.7.4-py3-none-any.whl.metadata (2.2 kB)
Collecting oauthlib>=1.0.3 (from social-auth-core==4.5.4->-r requirements.txt (line 32))
  Using cached oauthlib-3.2.2-py3-none-any.whl.metadata (7.5 kB)
Collecting requests-oauthlib>=0.6.1 (from social-auth-core==4.5.4->-r requirements.txt (line 32))
  Using cached requests_oauthlib-2.0.0-py2.py3-none-any.whl.metadata (11 kB)
Collecting PyJWT>=2.7.0 (from social-auth-core==4.5.4->-r requirements.txt (line 32))
  Using cached PyJWT-2.8.0-py3-none-any.whl.metadata (4.2 kB)
Collecting cryptography>=1.4 (from social-auth-core==4.5.4->-r requirements.txt (line 32))
  Using cached cryptography-42.0.8-cp39-abi3-manylinux_2_28_x86_64.whl.metadata (5.3 kB)
Collecting defusedxml>=0.5.0rc1 (from social-auth-core==4.5.4->-r requirements.txt (line 32))
  Using cached defusedxml-0.8.0rc2-py2.py3-none-any.whl.metadata (33 kB)
Collecting python3-openid>=3.0.10 (from social-auth-core==4.5.4->-r requirements.txt (line 32))
  Using cached python3_openid-3.2.0-py3-none-any.whl.metadata (1.6 kB)
Collecting graphql-core<3.3.0,>=3.2.0 (from strawberry-graphql==0.227.3->-r requirements.txt (line 33))
  Using cached graphql_core-3.2.3-py3-none-any.whl.metadata (10 kB)
Collecting python-dateutil<3.0.0,>=2.7.0 (from strawberry-graphql==0.227.3->-r requirements.txt (line 33))
  Using cached python_dateutil-2.9.0.post0-py2.py3-none-any.whl.metadata (8.4 kB)
Collecting mkdocstrings-python-legacy>=0.2.1 (from mkdocstrings[python-legacy]==0.25.1->-r requirements.txt (line 24))
  Using cached mkdocstrings_python_legacy-0.2.3-py3-none-any.whl.metadata (5.1 kB)
Collecting psycopg-c==3.1.18 (from psycopg[c,pool]==3.1.18->-r requirements.txt (line 28))
  Using cached psycopg-c-3.1.18.tar.gz (561 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
Collecting psycopg-pool (from psycopg[c,pool]==3.1.18->-r requirements.txt (line 28))
  Using cached psycopg_pool-3.2.2-py3-none-any.whl.metadata (2.6 kB)
Collecting cffi>=1.12 (from cryptography>=1.4->social-auth-core==4.5.4->-r requirements.txt (line 32))
  Using cached cffi-1.16.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.metadata (1.5 kB)
Collecting graphene<4,>=3.0 (from graphene-django>=2.0.0->django-graphiql-debug-toolbar==0.2.0->-r requirements.txt (line 6))
  Using cached graphene-3.3-py2.py3-none-any.whl.metadata (7.7 kB)
Collecting graphql-relay<4,>=3.1.1 (from graphene-django>=2.0.0->django-graphiql-debug-toolbar==0.2.0->-r requirements.txt (line 6))
  Using cached graphql_relay-3.2.0-py3-none-any.whl.metadata (12 kB)
Collecting promise>=2.1 (from graphene-django>=2.0.0->django-graphiql-debug-toolbar==0.2.0->-r requirements.txt (line 6))
  Using cached promise-2.3-py3-none-any.whl
Collecting text-unidecode (from graphene-django>=2.0.0->django-graphiql-debug-toolbar==0.2.0->-r requirements.txt (line 6))
  Using cached text_unidecode-1.3-py2.py3-none-any.whl.metadata (2.4 kB)
Collecting attrs>=22.2.0 (from jsonschema>=2.6.0->drf-spectacular==0.27.2->-r requirements.txt (line 17))
  Using cached attrs-23.2.0-py3-none-any.whl.metadata (9.5 kB)
Collecting jsonschema-specifications>=2023.03.6 (from jsonschema>=2.6.0->drf-spectacular==0.27.2->-r requirements.txt (line 17))
  Using cached jsonschema_specifications-2023.12.1-py3-none-any.whl.metadata (3.0 kB)
Collecting referencing>=0.28.4 (from jsonschema>=2.6.0->drf-spectacular==0.27.2->-r requirements.txt (line 17))
  Using cached referencing-0.35.1-py3-none-any.whl.metadata (2.8 kB)
Collecting rpds-py>=0.7.1 (from jsonschema>=2.6.0->drf-spectacular==0.27.2->-r requirements.txt (line 17))
  Using cached rpds_py-0.19.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.metadata (4.1 kB)
Collecting ghp-import>=1.0 (from mkdocs~=1.6->mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached ghp_import-2.1.0-py3-none-any.whl.metadata (7.2 kB)
Collecting mergedeep>=1.3.4 (from mkdocs~=1.6->mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached mergedeep-1.3.4-py3-none-any.whl.metadata (4.3 kB)
Collecting mkdocs-get-deps>=0.2.0 (from mkdocs~=1.6->mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached mkdocs_get_deps-0.2.0-py3-none-any.whl.metadata (4.0 kB)
Collecting pathspec>=0.11.1 (from mkdocs~=1.6->mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached pathspec-0.12.1-py3-none-any.whl.metadata (21 kB)
Collecting pyyaml-env-tag>=0.1 (from mkdocs~=1.6->mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached pyyaml_env_tag-0.1-py3-none-any.whl.metadata (4.1 kB)
Collecting watchdog>=2.0 (from mkdocs~=1.6->mkdocs-material==9.5.21->-r requirements.txt (line 23))
  Using cached watchdog-4.0.1-py3-none-manylinux2014_x86_64.whl.metadata (37 kB)
Collecting pytkdocs>=0.14 (from mkdocstrings-python-legacy>=0.2.1->mkdocstrings[python-legacy]==0.25.1->-r requirements.txt (line 24))
  Using cached pytkdocs-0.16.1-py3-none-any.whl.metadata (8.8 kB)
Collecting markdown-it-py>=2.2.0 (from rich>=10.0.0->django-rich==1.8.0->-r requirements.txt (line 11))
  Using cached markdown_it_py-3.0.0-py3-none-any.whl.metadata (6.9 kB)
Collecting pycparser (from cffi>=1.12->cryptography>=1.4->social-auth-core==4.5.4->-r requirements.txt (line 32))
  Using cached pycparser-2.22-py3-none-any.whl.metadata (943 bytes)
Collecting aniso8601<10,>=8 (from graphene<4,>=3.0->graphene-django>=2.0.0->django-graphiql-debug-toolbar==0.2.0->-r requirements.txt (line 6))
  Using cached aniso8601-9.0.1-py2.py3-none-any.whl.metadata (23 kB)
Collecting mdurl~=0.1 (from markdown-it-py>=2.2.0->rich>=10.0.0->django-rich==1.8.0->-r requirements.txt (line 11))
  Using cached mdurl-0.1.2-py3-none-any.whl.metadata (1.6 kB)
WARNING: The candidate selected for download or install is a yanked version: 'django' candidate (version 5.0.5 at https://files.pythonhosted.org/packages/60/5d/d829755fee56176e0cdb4aa0fa9bf09e4ee687d3ef508f43e64ed9ab9712/Django-5.0.5-py3-none-any.whl (from https://pypi.org/simple/django/) (requires-python:>=3.10))
Reason for being yanked: Release files have Windows end-of-line characters and are missing executable bits.
Using cached Django-5.0.5-py3-none-any.whl (8.2 MB)
Using cached django_cors_headers-4.3.1-py3-none-any.whl (12 kB)
Using cached django_debug_toolbar-4.3.0-py3-none-any.whl (223 kB)
Using cached django_filter-24.2-py3-none-any.whl (94 kB)
Using cached django_htmx-1.17.3-py3-none-any.whl (6.9 kB)
Using cached django_graphiql_debug_toolbar-0.2.0-py3-none-any.whl (7.3 kB)
Using cached django_mptt-0.16.0-py3-none-any.whl (115 kB)
Using cached django_prometheus-2.3.1-py2.py3-none-any.whl (29 kB)
Using cached django_redis-5.4.0-py3-none-any.whl (31 kB)
Using cached django_rich-1.8.0-py3-none-any.whl (7.1 kB)
Using cached django_rq-2.10.2-py2.py3-none-any.whl (56 kB)
Using cached django_taggit-5.0.1-py3-none-any.whl (61 kB)
Using cached django_tables2-2.7.0-py2.py3-none-any.whl (95 kB)
Using cached django_timezone_field-6.1.0-py3-none-any.whl (12 kB)
Using cached djangorestframework-3.15.1-py3-none-any.whl (1.1 MB)
Using cached drf_spectacular-0.27.2-py3-none-any.whl (102 kB)
Using cached drf_spectacular_sidecar-2024.5.1-py3-none-any.whl (2.4 MB)
Using cached feedparser-6.0.11-py3-none-any.whl (81 kB)
Using cached gunicorn-22.0.0-py3-none-any.whl (84 kB)
Using cached jinja2-3.1.4-py3-none-any.whl (133 kB)
Using cached Markdown-3.6-py3-none-any.whl (105 kB)
Using cached mkdocs_material-9.5.21-py3-none-any.whl (8.8 MB)
Using cached mkdocstrings-0.25.1-py3-none-any.whl (29 kB)
Using cached netaddr-1.2.1-py3-none-any.whl (2.3 MB)
Using cached nh3-0.2.17-cp37-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (777 kB)
Using cached pillow-10.3.0-cp311-cp311-manylinux_2_28_x86_64.whl (4.5 MB)
Using cached psycopg-3.1.18-py3-none-any.whl (178 kB)
Using cached PyYAML-6.0.1-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (757 kB)
Using cached requests-2.31.0-py3-none-any.whl (62 kB)
Using cached social_auth_app_django-5.4.1-py3-none-any.whl (26 kB)
Using cached social_auth_core-4.5.4-py3-none-any.whl (410 kB)
Using cached strawberry_graphql-0.227.3-py3-none-any.whl (290 kB)
Using cached strawberry_graphql_django-0.39.2-py3-none-any.whl (84 kB)
Using cached svgwrite-1.4.3-py3-none-any.whl (67 kB)
Using cached tablib-3.6.1-py3-none-any.whl (47 kB)
Using cached tzdata-2024.1-py2.py3-none-any.whl (345 kB)
Using cached asgiref-3.8.1-py3-none-any.whl (23 kB)
Using cached Babel-2.15.0-py3-none-any.whl (9.6 MB)
Using cached certifi-2024.7.4-py3-none-any.whl (162 kB)
Using cached charset_normalizer-3.3.2-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (140 kB)
Using cached click-8.1.7-py3-none-any.whl (97 kB)
Using cached colorama-0.4.6-py2.py3-none-any.whl (25 kB)
Using cached cryptography-42.0.8-cp39-abi3-manylinux_2_28_x86_64.whl (3.9 MB)
Using cached defusedxml-0.8.0rc2-py2.py3-none-any.whl (25 kB)
Using cached graphene_django-3.2.2-py2.py3-none-any.whl (114 kB)
Using cached graphql_core-3.2.3-py3-none-any.whl (202 kB)
Using cached idna-3.7-py3-none-any.whl (66 kB)
Using cached inflection-0.5.1-py2.py3-none-any.whl (9.5 kB)
Using cached jsonschema-4.23.0-py3-none-any.whl (88 kB)
Using cached MarkupSafe-2.1.5-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (28 kB)
Using cached mkdocs-1.6.0-py3-none-any.whl (3.9 MB)
Using cached mkdocs_autorefs-1.0.1-py3-none-any.whl (13 kB)
Using cached mkdocs_material_extensions-1.3.1-py3-none-any.whl (8.7 kB)
Using cached mkdocstrings_python_legacy-0.2.3-py3-none-any.whl (26 kB)
Using cached oauthlib-3.2.2-py3-none-any.whl (151 kB)
Using cached packaging-24.1-py3-none-any.whl (53 kB)
Using cached platformdirs-4.2.2-py3-none-any.whl (18 kB)
Using cached prometheus_client-0.20.0-py3-none-any.whl (54 kB)
Using cached pygments-2.18.0-py3-none-any.whl (1.2 MB)
Using cached PyJWT-2.8.0-py3-none-any.whl (22 kB)
Using cached pymdown_extensions-10.8.1-py3-none-any.whl (250 kB)
Using cached python_dateutil-2.9.0.post0-py2.py3-none-any.whl (229 kB)
Using cached python3_openid-3.2.0-py3-none-any.whl (133 kB)
Using cached redis-5.0.7-py3-none-any.whl (252 kB)
Using cached regex-2024.5.15-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (785 kB)
Using cached requests_oauthlib-2.0.0-py2.py3-none-any.whl (24 kB)
Using cached rich-13.7.1-py3-none-any.whl (240 kB)
Using cached rq-1.16.2-py3-none-any.whl (90 kB)
Using cached six-1.16.0-py2.py3-none-any.whl (11 kB)
Using cached sqlparse-0.5.1-py3-none-any.whl (44 kB)
Using cached typing_extensions-4.12.2-py3-none-any.whl (37 kB)
Using cached uritemplate-4.1.1-py2.py3-none-any.whl (10 kB)
Using cached urllib3-2.2.2-py3-none-any.whl (121 kB)
Using cached django_js_asset-2.2.0-py3-none-any.whl (4.7 kB)
Using cached psycopg_pool-3.2.2-py3-none-any.whl (38 kB)
Using cached attrs-23.2.0-py3-none-any.whl (60 kB)
Using cached cffi-1.16.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (464 kB)
Using cached ghp_import-2.1.0-py3-none-any.whl (11 kB)
Using cached graphene-3.3-py2.py3-none-any.whl (128 kB)
Using cached graphql_relay-3.2.0-py3-none-any.whl (16 kB)
Using cached jsonschema_specifications-2023.12.1-py3-none-any.whl (18 kB)
Using cached markdown_it_py-3.0.0-py3-none-any.whl (87 kB)
Using cached mergedeep-1.3.4-py3-none-any.whl (6.4 kB)
Using cached mkdocs_get_deps-0.2.0-py3-none-any.whl (9.5 kB)
Using cached pathspec-0.12.1-py3-none-any.whl (31 kB)
Using cached pytkdocs-0.16.1-py3-none-any.whl (37 kB)
Using cached pyyaml_env_tag-0.1-py3-none-any.whl (3.9 kB)
Using cached referencing-0.35.1-py3-none-any.whl (26 kB)
Using cached rpds_py-0.19.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (355 kB)
Using cached watchdog-4.0.1-py3-none-manylinux2014_x86_64.whl (83 kB)
Using cached text_unidecode-1.3-py2.py3-none-any.whl (78 kB)
Using cached aniso8601-9.0.1-py2.py3-none-any.whl (52 kB)
Using cached mdurl-0.1.2-py3-none-any.whl (10.0 kB)
Using cached pycparser-2.22-py3-none-any.whl (117 kB)
Building wheels for collected packages: psycopg-c
  Building wheel for psycopg-c (pyproject.toml) ... error
  error: subprocess-exited-with-error

  × Building wheel for psycopg-c (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [29 lines of output]
      running bdist_wheel
      running build
      running build_py
      creating build
      creating build/lib.linux-x86_64-cpython-311
      creating build/lib.linux-x86_64-cpython-311/psycopg_c
      copying psycopg_c/version.py -> build/lib.linux-x86_64-cpython-311/psycopg_c
      copying psycopg_c/__init__.py -> build/lib.linux-x86_64-cpython-311/psycopg_c
      copying psycopg_c/_psycopg.pyi -> build/lib.linux-x86_64-cpython-311/psycopg_c
      copying psycopg_c/py.typed -> build/lib.linux-x86_64-cpython-311/psycopg_c
      copying psycopg_c/pq.pxd -> build/lib.linux-x86_64-cpython-311/psycopg_c
      creating build/lib.linux-x86_64-cpython-311/psycopg_c/_psycopg
      copying psycopg_c/_psycopg/oids.pxd -> build/lib.linux-x86_64-cpython-311/psycopg_c/_psycopg
      copying psycopg_c/_psycopg/endian.pxd -> build/lib.linux-x86_64-cpython-311/psycopg_c/_psycopg
      copying psycopg_c/_psycopg/__init__.pxd -> build/lib.linux-x86_64-cpython-311/psycopg_c/_psycopg
      creating build/lib.linux-x86_64-cpython-311/psycopg_c/pq
      copying psycopg_c/pq/libpq.pxd -> build/lib.linux-x86_64-cpython-311/psycopg_c/pq
      copying psycopg_c/pq/__init__.pxd -> build/lib.linux-x86_64-cpython-311/psycopg_c/pq
      running build_ext
      building 'psycopg_c._psycopg' extension
      creating build/temp.linux-x86_64-cpython-311
      creating build/temp.linux-x86_64-cpython-311/psycopg_c
      creating build/temp.linux-x86_64-cpython-311/psycopg_c/types
      gcc -pthread -Wsign-compare -DDYNAMIC_ANNOTATIONS_ENABLED=1 -DNDEBUG -O2 -g -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecord-gcc-switches -m64 -mtune=generic -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection -D_GNU_SOURCE -fPIC -fwrapv -O2 -g -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecord-gcc-switches -m64 -mtune=generic -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection -D_GNU_SOURCE -fPIC -fwrapv -O2 -g -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecord-gcc-switches -m64 -mtune=generic -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection -D_GNU_SOURCE -fPIC -fwrapv -fPIC -I/usr/pgsql-13/include -I/opt/netbox/venv/include -I/usr/include/python3.11 -c psycopg_c/_psycopg.c -o build/temp.linux-x86_64-cpython-311/psycopg_c/_psycopg.o
      psycopg_c/_psycopg.c:1238:10: fatal error: pg_config.h: No such file or directory
       #include "pg_config.h"
                ^~~~~~~~~~~~~
      compilation terminated.
      error: command '/usr/bin/gcc' 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 psycopg-c
Failed to build psycopg-c
ERROR: ERROR: Failed to build installable wheels for some pyproject.toml based projects (psycopg-c)```

[scu-cmoore1]

The issue may be related to using a third-party package for PostgreSQL; we are currently investigating that. Slack message archive found
https://netdev-community.slack.com/archives/C01P0FRSXRV/p1718801515760079

[Jonb0y89]

I am also having this exact same issue. Was there a fix planned for this yet? Upgrading from 3.7.2 > 4.0.8 Thanks!

[Jonb0y89]

Ok I have fixed it for my instance. Fix was to install python.3.12-devel as well as the python 3.12 package. So:

yum install python3.12
yum install python3.12-devel.x86_64

Hope this helps!

[scu-cmoore1]

We were able to fix the issue by installing postgresql13-devel due to using a third-party install of Postgresql.

dnf install -y postgresql13-devel