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/d038533b-3484-4943-880f-44f365a5d64an%40googlegroups.com.
