Re: Problem with table metaemail at make_catalog_backup.pl

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
>