On 9 Jan 2007 at 14:08, Doug Sampson wrote: > > 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.
These tables were introduced in Bacula 2.0 and during an upgrade, will be created by src/cats/update_postgresql_tables.in. I will test and patch the code if I can replicate your problem. I'll also apply the patch to the FreeBSD port. thanks -- Dan Langille : Software Developer looking for work my resume: http://www.freebsddiary.org/dan_langille.php PGCon - The PostgreSQL Conference - http://www.pgcon.org/ ------------------------------------------------------------------------- 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
