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/6468b649-8ae6-497b-823f-b847476aaabfn%40googlegroups.com.
