Hi.. I get the below error when trying to run the catalog backup. If I change the user to postgres instead of bacula it will work (/make_catalog_backup bacula postgres).
I am sure it is a permission thing within postgresql but I am not sure what to change. Does anybody have any suggestions? tia... Daren =================================================================== 23-Nov 04:38 backup-dir: BeforeJob: run command "/opt/bacula/bin/make_catalog_backup bacula bacula" 23-Nov 04:38 backup-dir: BeforeJob: pg_dump: SQL command failed 23-Nov 04:38 backup-dir: BeforeJob: pg_dump: Error message from server: ERROR: permission denied for relation location 23-Nov 04:38 backup-dir: BeforeJob: pg_dump: The command was: LOCK TABLE public."location" IN ACCESS SHARE MODE 23-Nov 04:38 backup-dir: BackupCatalog.2006-11-22_23.10.00 Error: Runscript: BeforeJob returned non-zero status=1. ERR=Child exited with code 1 ------------------------------------------------------------------------- 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
