Re: [Bacula-users] PG database error

2009-04-08 Thread Tom Plancon
Craig, Thanks for the response. I altered all the tables to owner "bacula", ran catalogbackup and got the same error: 08-Apr 10:04 p-plover-dir JobId 5: BeforeJob: pg_dump: Error message from server: ERROR: permission denied for relation contact_userid_seq So I went in to the db via phpPgAdm

Re: [Bacula-users] PG database error

2009-04-07 Thread Craig Ringer
T. Plancon wrote: > 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' Whoops. You should create the tables under user `bacula' if that's the user ID your director runs under. > create_

[Bacula-users] PG database error

2009-04-07 Thread T. Plancon
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