Hi Seth, i did an upgrade from bareos 17 --> 21 without any problems (Server CentOS 7, with one stop at bareos 20). I switched from mysql to psql 13 on bareos 20. During the bareos-dbcopy run i got:
------------------------------------------------------- Could not end Sql Copy: cats/postgresql_batch.cc:385 error ending batch mode: ERROR: value "3158757611" is out of range for type integer CONTEXT: COPY media, line 1, column volwrites: "3158757611" Solution: UPDATE Media SET VolWrites = 0 WHERE VolWrites > '2000000000'; ------------------------------------------------------- But this is well documented, too. Due to the huge Size of the DB, i created an extra VM with enough space for the migration. We switched from CentOS 7 to debian 11 without any problems (Client + Server) greets Steffen ________________________________ Von: [email protected] <[email protected]> im Auftrag von Seth Galitzer <[email protected]> Gesendet: Montag, 30. Januar 2023 21:57 An: bareos-users <[email protected]> Betreff: [bareos-users] upgrade 18 -> 22 reasonable? Don't know why I stayed on 18 for so long, but looks like I need to go all the way to 22 to get clients that will install cleanly on Debian 11. Server is CentOS 7. Any issues I should watch out for making this large leap? Is it better to do incremental upgrades, or should the single leap be ok? Thanks. Seth -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/b52c08cd-4fe9-4530-87ce-094ff58465a0n%40googlegroups.com<https://groups.google.com/d/msgid/bareos-users/b52c08cd-4fe9-4530-87ce-094ff58465a0n%40googlegroups.com?utm_medium=email&utm_source=footer>. -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/BEZP281MB19599DDEF386772DCCCDDD60C6DA9%40BEZP281MB1959.DEUP281.PROD.OUTLOOK.COM.
