Upgrade Netbox 4.4 to 4.4.1 fails because of upgrade pscyopg/psycopg-c from 3.2.9 to 3.2.10

[GvC-cg]

I tried to upgrade yesterday Netbox 4.3.7 to Netbox 4.4.1 but got an error. So in the end I first upgraded Netbox 4.3.7 to 4.4. This went without any trouble at all. But the moment I try to upgrade 4.4 to 4.4.1 I again get below error.

File "/opt/netbox/venv/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 332, in get_new_connection
connection = self.Database.connect(**conn_params)
File "/opt/netbox/venv/lib/python3.10/site-packages/psycopg/connection.py", line 131, in connect
and rv.pgconn.used_gssapi
File "psycopg_c/pq/pgconn.pyx", line 224, in psycopg_c.pq.PGconn.used_gssapi. get
File "psycopg_c/pq/pgconn.pyx", line 38, in psycopg_c.pq._check_supported
django.db.utils.NotSupportedError: PQconnectionUsedGSSAPI requires libpq from PostgreSQL 16.0 on the client; version 13.20 available instead

After putting in /opt/netbox/local_requirements.txt the old versions of psycopq (see below) I had no trouble in upgrading Netbox to 4.4.1.
psycopg==3.2.9
psycopg-c==3.2.9

Anyone else familiar with that phenomenon?

Regards,
Gerard

[nastea1]

Experienced similar issue going from 4.2.5 to 4.4.4 today. Not sure why but your posted "fix" above did allow me to continue with the upgrade.

[jnovinger]

This feels like a regression with psycopg 3.2.10. psycopg 3.2.10 added code that calls libpq's PQconnectionUsedGSSAPI(), which requires libpq 16+ (PR #1137). The code has version guards to avoid calling this on older libpqs, but they don't appear to be working correctly in your case.

Your workaround (pinning to psycopg 3.2.9) is definitely valid. The other option is upgrading libpq client libraries to version 16+, which is compatible with older PostgreSQL servers. That said, please verify my claims below before proceeding, I'm no PostgreSQL admin expert.

PostgreSQL's libpq client library aims to maintain backward compatibility with older servers - the protocol has been stable since 7.4. Upgrading to libpq 16 while running a PostgreSQL 14 or 15 server should be supported, as I understand it. See https://www.postgresql.org/docs/current/protocol.html and discussions like https://www.postgresql.org/message-id/[email protected] for confirmation.

[ychtourou12-ai]

same here when move from netbox 4.4.2 to 4.4.4 ( i already downgrade to psycopg[c,pool]==3.2.9 , to terminate upgrade to 4.4.2 )