Bacula-users

[Bacula-users] PG database error

2009-04-07 14:30:39
Subject: [Bacula-users] PG database error
From: "T. Plancon" <tplancon AT bkaarchs DOT com>
To: Bacula <bacula-users AT lists.sourceforge DOT net>
Date: Tue, 07 Apr 2009 14:30:07 -0400
Hello,

I'm setting up bacula 2.4.2 on a CentOS 5 system using postgresql as the
db. I've used the scripts in /usr/lib/bacula, running as user
'postgres', create_postgresql_database, make_postgresql_tables,
grant_postgresql_privileges in that order. An initial backup ran fine,
but I got this error when doing the catalog backup:

07-Apr 14:00 p-plover-dir JobId 1: BeforeJob: run command 
"/usr/lib/bacula/make_catalog_backup bacula bacula"
07-Apr 14:00 p-plover-dir JobId 1: BeforeJob: pg_dump: SQL command failed
07-Apr 14:00 p-plover-dir JobId 1: BeforeJob: pg_dump: Error message from 
server: ERROR:  permission denied for relation contact_userid_seq
07-Apr 14:00 p-plover-dir JobId 1: BeforeJob: pg_dump: The command was: SELECT 
sequence_name, last_value, increment_by, CASE WHEN increment_by > 0 AND 
max_value = 9223372036854775807 THEN NULL      WHEN increment_by < 0 AND 
max_value = -1 THEN NULL      ELSE max_value END AS max_value, CASE WHEN 
increment_by > 0 AND min_value = 1 THEN NULL      WHEN increment_by < 0 AND 
min_value = -9223372036854775807 THEN NULL      ELSE min_value END AS 
min_value, cache_value, is_cycled, is_called from contact_userid_seq
07-Apr 14:00 p-plover-dir JobId 1: Error: Runscript: BeforeJob returned 
non-zero status=1. ERR=Child exited with code 1

Did I miss a step here? Any help is appreciated! Thanks!

-- 
Tom Plancon
CAD/IS Manager
BKA Architects, Inc.
142 Crescent St.
Brockton, MA 02302
508-583-5603
tplancon AT bkaarchs DOT com
 


------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>