Sorry I just read the rest of your mail......it has been one of those
days.
Bacula version: 2.2.5
OS: CentOS5
The output requested:
bacula=# \dp
Access privileges for database "bacula"
Schema | Name | Type |
Access privileges
--------+----------------------------------+----------+-----------------------------------------
public | basefiles | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | basefiles_baseid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | cdimages | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | client | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | client_clientid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | client_group | table |
public | client_group_client_group_id_seq | sequence |
public | client_group_member | table |
public | counters | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | device | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | device_deviceid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | file | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | file_fileid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | filename | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | filename_filenameid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | fileset | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | fileset_filesetid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | job | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | job_jobid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | jobmedia | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | jobmedia_jobmediaid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | location | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | location_locationid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | locationlog | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | locationlog_loclogid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | log | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | log_logid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | media | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | media_mediaid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | mediatype | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | mediatype_mediatypeid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | path | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | path_pathid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | pool | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | pool_poolid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | status | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | storage | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | storage_storageid_seq | sequence |
{root=arwdRxt/root,bacula=rw/root}
public | unsavedfiles | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
public | version | table |
{root=arwdRxt/root,bacula=arwdRxt/root}
(40 rows)
-----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
