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 bareos-users+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/bareos-users/b5846b61-a5f8-481a-badb-7b09d596bbcfn%40googlegroups.com.
