It is probably a privileges issue with the metaemail table.
Run psql, connect to the bacula database and check the output of
\dp metaemail
I have:
Schema | Name | Type | Access privileges | Column privileges |
Policies
--------+-----------+-------+---------------------------+-------------------+----------
public | metaemail | table | postgres=arwdDxt/postgres+| |
| | | bacula=arwdDxt/postgres | |
(1 row)
You can also compare it to the output of
\dp job
If it differs, then running the grant_bacula_privileges script as root will
probably fix it.
__Martin
>>>>> On Sat, 6 Sep 2025 15:08:46 +0200, Johannes Becker said:
>
> Hello,
>
> After a server crash I had to do a fresh install of bacula and went from
> version 13 to 15. OS is Ubuntu 24.04 LTS.
>
> After installing Bacula I used the scripts to update the dump that I did
> before. Now backup and restore work fine.
>
> However backing up the catalog generates the error:
>
> BeforeJob: pg_dump: error: query failed: ERROR: permission denied for
> table metaemail
>
>
> When I look for this table in the database I can see:
>
> | schemaname | tablename | tableowner | tablespace |
> hasindexes | hasrules | hastriggers | rowsecurity |
> +--------------------+--------------------------+------------+------------+------------+----------+-------------+-------------+
>
>
> ... lots of stuff deleted...
>
> | public | metaemail | postgres | |
> t | f | f | f |
>
> A search did not give me any hints were to search. Does anyone have an idea
> where this goes wrong?
>
>
> Johannes
>
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
