Bug 46063 - remove specific postgresql version requirement from ucs-school-import-http-api
remove specific postgresql version requirement from ucs-school-import-http-api
Status: RESOLVED WORKSFORME
Product: UCS@school
Classification: Unclassified
Component: HTTP-API (Kelvin)
UCS@school 4.4
Other Linux
: P5 normal (vote)
: ---
Assigned To: UCS@school maintainers
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2018-01-17 12:13 CET by Daniel Tröder
Modified: 2020-08-27 20:17 CEST (History)
2 users (show)

See Also:
What kind of report is it?: Bug Report
What type of bug is this?: 2: Improvement: Would be a product improvement
Who will be affected by this bug?: 2: Will only affect a few installed domains
How will those affected feel about the bug?: 2: A Pain – users won’t like this once they notice it
User Pain: 0.046
Enterprise Customer affected?:
School Customer affected?: Yes
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Daniel Tröder univentionstaff 2018-01-17 12:13:54 CET
+++ This bug was initially created as a clone of Bug #46054 +++

The ucs-school-import-http-api package has a requirement for univention-postgresql-9.4, because it historically wanted to store JSON in the DB. That is not the case anymore, but the dependency has not been loosened.

UCS 4.1 ships PostgreSQL 9.1, psycopg2 2.4.5
UCS 4.2 ships PostgreSQL 9.4, psycopg2 2.5.4
UCS 4.3 ships PostgreSQL 9.6, psycopg2 2.6.2

Django 1.8 support PostgreSQL 9.0 and higher, psycopg2 >= 2.4.5
Django 1.9 support PostgreSQL 9.1 and higher, psycopg2 >= 2.4.5
Django 1.10 support PostgreSQL 9.2 and higher, psycopg2 >= 2.4.5
Django 1.11 support PostgreSQL 9.3 and higher, psycopg2 >= 2.5.4
Django 2.0 support PostgreSQL >= 9.3, psycopg2 >= 2.5.4

(If django.contrib.postgres would be used, psycopg2 2.5+ would be required. But this is currently not the case.)

Release 4.2-0-0	Scope ucs-school-4.2 ships Django 1.8.18-1~bpo8+1
Release 4.3-0-0 ships Django 1:1.10.7-2

Depend only on univention-postgresql, without specific version.
In UCS 4.2 this should allow running ucs-school-import on both PostgreSQL 9.1 and 9.4, in UCS 4.3 it will require PostgreSQL 9.4 or PostgreSQL 9.6.
Comment 1 Daniel Tröder univentionstaff 2020-08-27 20:17:33 CEST
Already done in commit

[4.3 a42b4119] Bug #46533: depend on current postgres

for Bug #46533.