psycopg-c 3.3.2 error upgrading 4.3.5 to 4.5.2

[warriorsoul15]

NetBox Edition

NetBox Community

NetBox Version

v4.5.2

Python Version

3.12

Steps to Reproduce

When I run PYTHON=/usr/bin/python3.12 ./upgrade.sh
(rhel 9)

the upgrade script errors out on pstcopg-c 3.3.2

Expected Behavior

I would expect it to complete creating the venv

Observed Behavior

This error is raised

Collecting psycopg-c==3.3.2 (from psycopg[c,pool]==3.3.2->-r requirements.txt (line 32))
  Using cached psycopg_c-3.3.2.tar.gz (624 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... error
  error: subprocess-exited-with-error

  × Preparing metadata (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [10 lines of output]
      /tmp/pip-build-env-bfcvsma1/overlay/lib/python3.12/site-packages/setuptools/config/pyprojecttoml.py:72: _ExperimentalConfiguration: `[tool.setuptools.ext-modules]` in `pyproject.toml` is still *experimental* and likely to change in future releases.
        config = read_configuration(filepath, True, ignore_option_errors, dist)
      running dist_info
      creating /tmp/pip-modern-metadata-l0q1o21x/psycopg_c.egg-info
      writing /tmp/pip-modern-metadata-l0q1o21x/psycopg_c.egg-info/PKG-INFO
      writing dependency_links to /tmp/pip-modern-metadata-l0q1o21x/psycopg_c.egg-info/dependency_links.txt
      writing top-level names to /tmp/pip-modern-metadata-l0q1o21x/psycopg_c.egg-info/top_level.txt
      writing manifest file '/tmp/pip-modern-metadata-l0q1o21x/psycopg_c.egg-info/SOURCES.txt'
      couldn't run 'pg_config' --includedir: [Errno 2] No such file or directory: 'pg_config'
      error: [Errno 2] No such file or directory: 'pg_config'
      [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.
╰─> psycopg-c

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

[sleepinggenius2]

You have a missing dependency on your server. The specific one for this error is libpq-dev under Debian/Ubuntu or libpq-devel under Red Hat. Make sure you have completed https://netboxlabs.com/docs/netbox/installation/netbox/#install-system-packages.