Hello Serge, On 1/14/22 15:15, UGE Serge (FR2010) wrote:
Hello, I was running Bacula 9.6.5-1 on Centos 8.4 since July 2020, and in the "make_postgresql_tables" script there was this table in particular: CREATE TABLE Filename which was described in the Catalog Schema in the document Bacula Community API. Now I run Bacula 11.0.5-1 since August 2021 and the table "Filename" does not appear any more in the installation scripts. I checked the new docs but I did not found anything about this. Can you indicate me if a replacement table exists or if it is a new structure of the catalog, or if there is a miss in my distribution "make_postgresql_tables" script ?
This table no longer exists in the catalog, you need to run the upgrade procedure described in the manual with update_bacula_tables + grant_bacula_privileges. Depending on the catalog size, it can take some time.
If you had custom queries using this table, you need to update them. The Filename information is now directly in the File table. (FilenameId -> Filename)
Hope it helps! Best Regards, Eric _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users