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 -- 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
