Re: Problem with table metaemail at make_catalog_backup.pl

@Martin:
I checked \dp metaemail and got:
bacula=# \dp metaemail
                               Access privileges
 Schema |   Name    | Type  | Access privileges | Column privileges |
Policies
--------+-----------+-------+-------------------+-------------------+----------
 public | metaemail | table |                   |                   |
(1 row)

bacula=# \dp job
                            Access privileges
 Schema | Name | Type  | Access privileges | Column privileges | Policies
--------+------+-------+-------------------+-------------------+----------
 public | job  | table |                  |                   |

Obviously the privileges were missing. I modified the
grant_postgres_privileges script to only run the part related to
privileges. And voila the catalog backup script runs.

Thank you guys

Johannes

On Mon, Sep 8, 2025 at 1:31 PM Martin Simmons <[email protected]> wrote:

> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users