Ok thanks for the information, I will try to reproduce such case, but as our testing framework is doing such workflow all the time without any trouble, I'm fearing to not see any failures, but who knows.
Access to previous version is reserved to subscription, you can contact sales at bareos.com if you want. On Wednesday, 5 February 2025 at 18:51:21 UTC+1 Stefan Harbich wrote: > Hallo Bruno, before that, several Bareos versions were installed. 19, 20, > 21 and 22. Can I switch back to Community Version 23? > > Bruno Friedmann (bruno-at-bareos) schrieb am Mittwoch, 5. Februar 2025 um > 10:52:04 UTC+1: > >> You may have a configuration which create some troubles, as on a pure >> debian 11 up to date >> I've a coherency between client and server >> >> psql (13.18 (Debian 13.18-0+deb11u1)) >> Type "help" for help. >> >> postgres=# select version(); >> version >> >> ----------------------------------------------------------------------------------------------------------------------------- >> PostgreSQL 13.18 (Debian 13.18-0+deb11u1) on x86_64-pc-linux-gnu, >> compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit >> (1 row) >> >> On Wednesday, 5 February 2025 at 10:28:33 UTC+1 Bruno Friedmann >> (bruno-at-bareos) wrote: >> >>> Normally it shouldn't happen, as bareos user is the owner of the >>> database on system using dbconfig. >>> Can you check this, and especially which owner is set for the view. >>> if it is different from the other tables and view, please transfert the >>> ownership and retry db-reconfigure. >>> >>> I'll try to setup a test environment with debian 11 as system. >>> Do you know if that system has previous bareos version installed before >>> 23.1.1 and if yes since which version. >>> >>> On Wednesday, 5 February 2025 at 10:22:38 UTC+1 Stefan Harbich wrote: >>> >>>> I can delete the database and create a new one. But for large >>>> customers, an update has to work. >>>> >>>> Stefan Harbich schrieb am Mittwoch, 5. Februar 2025 um 10:20:53 UTC+1: >>>> >>>>> Hi Bruno, >>>>> >>>>> OS >>>>> ... >>>>> root@dsme01:~# lsb_release -a >>>>> No LSB modules are available. >>>>> Distributor ID: Debian >>>>> Description: Debian GNU/Linux 11 (bullseye) >>>>> Release: 11 >>>>> Codename: bullseye >>>>> ... >>>>> PG >>>>> ... >>>>> root@dsme01:~# psql -h localhost -U postgres >>>>> psql (13.18 (Debian 13.18-0+deb11u1), Server 12.13 (Debian >>>>> 12.13-1.pgdg100+1)) >>>>> Geben Sie »help« für Hilfe ein. >>>>> >>>>> postgres=# SELECT version(); >>>>> version >>>>> >>>>> >>>>> -------------------------------------------------------------------------------------------------------------------- >>>>> PostgreSQL 12.13 (Debian 12.13-1.pgdg100+1) on x86_64-pc-linux-gnu, >>>>> compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit >>>>> (1 Zeile) >>>>> ... >>>>> I updated my system by: >>>>> ... >>>>> apt update && apt upgrade. After update bareos open >>>>> "bareos-database-common" and i see the erro message. >>>>> ... >>>>> Bruno Friedmann (bruno-at-bareos) schrieb am Mittwoch, 5. Februar 2025 >>>>> um 09:58:16 UTC+1: >>>>> >>>>>> Hi Stefan, what OS and version, and also pg version used ? >>>>>> >>>>>> How do you do the database upgrade (check history to see what you've >>>>>> done). >>>>>> >>>>>> On Wednesday, 5 February 2025 at 08:39:51 UTC+1 Stefan Harbich wrote: >>>>>> >>>>>>> Hello, >>>>>>> when updating to version 24 I get the following error message: >>>>>>> "An error occurred while upgrading the database: >>>>>>> "NOTE: Index >>file_jobid_idx<< does not exist, will be skipped >>>>>>> ERROR: Authorization only for owner of view backup_unit_overview" >>>>>>> Everything worked fine under Bareos 23.1.1 >>>>>>> What can I do? >>>>>>> Greetings from Stefan Harbich >>>>>>> >>>>>> -- 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 visit https://groups.google.com/d/msgid/bareos-users/f02d0af2-4b47-43af-9308-4e904f15e256n%40googlegroups.com.
