> On 9 Jan 2007 at 13:52, Doug Sampson wrote: > > > I'm getting an PGSQL error each time I attempt to dump > bacula to a SQL file > > during catalog backup as follows: > > > > [EMAIL PROTECTED]:/usr/local/share/bacula# > > /usr/local/share/bacula/make_catalog_backup1 bacula bacula > > pg_dump: attempt to lock table "location" failed: ERROR: > permission denied > > for relation location > > Sounds like insufficient permisison. Get into psql and issue this > command please: > > \dp location > > It will show us the permissions for that table. My bet: bacula has > insufficient rights. > > Please also show \dp files
A friend told me to use PGAdmin on my Windows machine to fix the permission errors. I found that three tables were missing permissions for bacula- location, locationlog, & log. I added privileges for bacula (as well as root) to these 3 tables. The 'make_catalog_backup1' file now executes properly. Did the file grant_bacula_privileges overlook these three tables? Did I not properly update privileges in the first place? I stopped PGSQL before portupgrading Bacula to 2.0. I then ran ./update_bacula_tables. Edited the config files to remove any references to 'AcceptAnyVolume=Yes' before starting Bacula. ~Doug ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
