@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 <mar...@lispworks.com> 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
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
