[pkg-bacula-devel] Handling DB Upgrades for 11

[Sven Hartge]

Hi .*,

let's make a new thread for this issue.

Carsten, the SQL extractor was written (or at least last touched) by you, 
so you can provide the most input here.

I am unsure on how to handle the DB upgrade from 9.4.2 to 11.0.x at the 
current moment.

What is evident is that the current install-dbconfig script and its awk 
companion are not able to extract the right upgrade path on their own.

I currently lean towards the approach to patch upstreams upgrade files and 
remove every branching path that is not used by us, for example the ones 
upgrading from 5.x or 7.x to 11, as those could only happen when a user 
tries to upgrade from Debian 8 or 9 directly to Debian 11, which is 
something not supported by Debian as a whole.

By removing all the branching paths we would get a clean upgrade script 
the extractor would work on again *and* the script would be still usable 
in case a user wants/needs to do a fully manual non-dbconfig upgrade.

Comments?

Grüße,
Sven.