When the pg_dump command is run manually it works. My pg_hba.conf is set to allow all local users full access to the bacula DB
What now? -----Original Message----- From: Dan Langille <[EMAIL PROTECTED]> To: Janco van der Merwe <[EMAIL PROTECTED]> Cc: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] Postgres Dump command fails Date: Thu, 13 Dec 2007 07:57:34 -0500 Janco van der Merwe wrote: > Hi, > > Can someone please help me with the below? I'm not a BD expert so I > don't have the faintest idea how to fix this. > > The permissions in the pg_hba.conf has been working for over 6 months > and I suddenly received these errors after a Zabbix database was > removed. > > -------- Forwarded Message -------- > > Subject: Bacula: Backup Error of carssrv4-fd Full > Date: Thu, 13 Dec 2007 01:31:01 +0200 (SAST) > > 13-Dec 01:31 carssrv4-dir JobId 185: BeforeJob: run command > "/usr/local/etc/bacula/make_catalog_backup bacula bacula xxxxxxx " If you issue that command from the command line, does it succeed? By the way, if non-trusted users are on this system, and even if they aren't, you can avoid having the password in this email by using .pgpass in Bacula's home dir: http://www.postgresql.org/docs/8.2/static/libpq-pgpass.html > 13-Dec 01:31 carssrv4-dir JobId 185: BeforeJob: pg_dump: SQL command failed > 13-Dec 01:31 carssrv4-dir JobId 185: BeforeJob: pg_dump: Error message from > server: ERROR: permission denied for relation client_group What are the table permissions? $ psql bacula Welcome to psql 8.2.5, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit bacula=# \dp They should all be simliar permissions for the bacula user. BTW, you didn't tell us what version of Bacula, or the OS you are using. > 13-Dec 01:31 carssrv4-dir JobId 185: BeforeJob: pg_dump: The command was: > LOCK TABLE public.client_group IN ACCESS SHARE MODE How odd, but let's check the permissions first. > 13-Dec 01:31 carssrv4-dir JobId 185: Error: Runscript: BeforeJob returned > non-zero status=1. ERR=Child exited with code 1 ------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
