On Tuesday, May 27, 2014 12:40:33 PM UTC+2, Xinity wrote: > On Tuesday, May 27, 2014 10:23:51 AM UTC+2, Marco van Wieringen wrote: > > > On 05/26/14 06:00 PM, Xinity wrote: > > > > > > > hi all, > > > > > > > > > > > > > > i have a strange issue, when i try to manually backup the MyCatalog DB > > > (postgresql), i have a strange error message talking about: > > > > > > > pg_dump: [archiver (db)] query failed: ERREUR: access denied for the > > > relation webacula_client_acl_id_seq > > > > > > > > > > > > > > bconsole is working perfectly and i can restore files perfectly too. > > > > > > > > > > > > > > anyone may knows why does the Catalog dump fails ? > > > > > > It seems the bareos user doesn't have grants on your webacula tables > > > > > > and sequences. As the webacula tables areinserted into the same database > > > > > > that bareos uses on a dump of the database it will also try to dump > > > > > > the webacula tables but for that it needs access to those tables which it > > > > > > apparently doesn't. Looks tobe a problem with the packaging not giving the > > > > > > right grants to the bareos user. > > > > > > > > > > > > -- > > > > > > Marco van Wieringen [email protected] > > > > > > Bareos GmbH & Co. KG Phone: +49-221-63069389 > > > > > > http://www.bareos.com > > > > > > > > > > > > Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 > > > > > > Komplementär: Bareos Verwaltungs-GmbH > > > > > > Geschäftsführer: Stephan Dühr, M. Außendorf, J. Steffens, > > > > > > P. Storz, M. v. Wieringen > > > > Hy marco , > > > > thanks for the answer, any "easy" way to fix that ? > > > > Regards
FWIT i've fixed it myself, just added USAGE and SELECT to user bareos on all webacula sequences. now Catalog Backup works perfectly ! Regards, -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
