Re: [Bacula-users] Postgres Error

Hi Martin,
It looks like make_bacula_tables succeeded. There were some notices (not 
errors) though, which are provided below:

[pgsql@bmir-backup-dir /usr/local]$ share/bacula/make_bacula_tables
Making PostgreSQL tables
psql:<stdin>:7: NOTICE:  CREATE TABLE will create implicit sequence 
"filename_filenameid_seq" for serial column "filename.filenameid"
psql:<stdin>:7: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit 
index "filename_pkey" for table "filename"
CREATE TABLE
ALTER TABLE
CREATE INDEX
psql:<stdin>:17: NOTICE:  CREATE TABLE will create implicit sequence 
"path_pathid_seq" for serial column "path.pathid"
psql:<stdin>:17: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "path_pkey" for table "path"
CREATE TABLE
ALTER TABLE
CREATE INDEX
psql:<stdin>:33: NOTICE:  CREATE TABLE will create implicit sequence 
"file_fileid_seq" for serial column "file.fileid"
psql:<stdin>:33: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "file_pkey" for table "file"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:<stdin>:84: NOTICE:  CREATE TABLE will create implicit sequence 
"job_jobid_seq" for serial column "job.jobid"
psql:<stdin>:84: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "job_pkey" for table "job"
CREATE TABLE
CREATE INDEX
CREATE TABLE
CREATE INDEX
psql:<stdin>:99: NOTICE:  CREATE TABLE will create implicit sequence 
"location_locationid_seq" for serial column "location.locationid"
psql:<stdin>:99: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "location_pkey" for table "location"
CREATE TABLE
psql:<stdin>:109: NOTICE:  CREATE TABLE will create implicit sequence 
"fileset_filesetid_seq" for serial column "fileset.filesetid"
psql:<stdin>:109: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "fileset_pkey" for table "fileset"
CREATE TABLE
CREATE INDEX
psql:<stdin>:126: NOTICE:  CREATE TABLE will create implicit sequence 
"jobmedia_jobmediaid_seq" for serial column "jobmedia.jobmediaid"
psql:<stdin>:126: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "jobmedia_pkey" for table "jobmedia"
CREATE TABLE
CREATE INDEX
psql:<stdin>:178: NOTICE:  CREATE TABLE will create implicit sequence 
"media_mediaid_seq" for serial column "media.mediaid"
psql:<stdin>:178: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "media_pkey" for table "media"
CREATE TABLE
CREATE INDEX
psql:<stdin>:188: NOTICE:  CREATE TABLE will create implicit sequence 
"mediatype_mediatypeid_seq" for serial column "mediatype.mediatypeid"
psql:<stdin>:188: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "mediatype_pkey" for table "mediatype"
CREATE TABLE
psql:<stdin>:195: NOTICE:  CREATE TABLE will create implicit sequence 
"storage_storageid_seq" for serial column "storage.storageid"
psql:<stdin>:195: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "storage_pkey" for table "storage"
CREATE TABLE
psql:<stdin>:214: NOTICE:  CREATE TABLE will create implicit sequence 
"device_deviceid_seq" for serial column "device.deviceid"
psql:<stdin>:214: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "device_pkey" for table "device"
CREATE TABLE
psql:<stdin>:246: NOTICE:  CREATE TABLE will create implicit sequence 
"pool_poolid_seq" for serial column "pool.poolid"
psql:<stdin>:246: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "pool_pkey" for table "pool"
CREATE TABLE
CREATE INDEX
psql:<stdin>:259: NOTICE:  CREATE TABLE will create implicit sequence 
"client_clientid_seq" for serial column "client.clientid"
psql:<stdin>:259: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "client_pkey" for table "client"
CREATE TABLE
CREATE INDEX
psql:<stdin>:270: NOTICE:  CREATE TABLE will create implicit sequence 
"log_logid_seq" for serial column "log.logid"
psql:<stdin>:270: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "log_pkey" for table "log"
CREATE TABLE
CREATE INDEX
psql:<stdin>:285: NOTICE:  CREATE TABLE will create implicit sequence 
"locationlog_loclogid_seq" for serial column "locationlog.loclogid"
psql:<stdin>:285: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "locationlog_pkey" for table "locationlog"
CREATE TABLE
psql:<stdin>:297: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "counters_pkey" for table "counters"
CREATE TABLE
psql:<stdin>:309: NOTICE:  CREATE TABLE will create implicit sequence 
"basefiles_baseid_seq" for serial column "basefiles.baseid"
psql:<stdin>:309: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "basefiles_pkey" for table "basefiles"
CREATE TABLE
CREATE INDEX
psql:<stdin>:320: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "unsavedfiles_pkey" for table "unsavedfiles"
CREATE TABLE
psql:<stdin>:327: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "cdimages_pkey" for table "cdimages"
CREATE TABLE
psql:<stdin>:335: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "pathhierarchy_pkey" for table "pathhierarchy"
CREATE TABLE
CREATE INDEX
psql:<stdin>:347: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "pathvisibility_pkey" for table "pathvisibility"
CREATE TABLE
CREATE INDEX
CREATE TABLE
psql:<stdin>:361: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index "status_pkey" for table "status"
CREATE TABLE
INSERT 0 1
INSERT 0 1
.
.
INSERT 0 1
INSERT 0 1
Creation of Bacula PostgreSQL tables succeeded.

BTW, it does not look like there was a jobhisto table created.

Mike


On 05/18/2011 04:26 AM, Martin Simmons wrote:
>>>>>> On Tue, 17 May 2011 20:40:27 -0700, Mike Seda said:
>> Hi All,
>> I'm currently attempting to stand up a Bacula Director on FreeBSD 8.2.
>>
>> I installed the following packages from FreeBSD Ports:
>> bacula-client-5.0.3
>> bacula-server-5.0.3
>> postgresql-client-8.3.14,1
>> postgresql-server-8.3.14
>>
>> Everything has gone pretty well so far, but I just ran into the error below:
>> [pgsql@bmir-backup-dir /usr/local]$ share/bacula/grant_bacula_privileges
>> Granting PostgreSQL privileges
>> CREATE ROLE
>> GRANT
>> GRANT
>> .
>> .
>> GRANT
>> GRANT
>> psql:<stdin>:38: ERROR:  relation "jobhisto_jobid_seq" does not exist
>> GRANT
>> GRANT
>> .
>> .
>> GRANT
>> GRANT
>> Privileges for user bacula granted on database bacula.
>>
>> Any thoughts?
> Was make_bacula_tables 100% successful?  In particular, did it create the
> jobhisto table?
>
> __Martin
>
> ------------------------------------------------------------------------------
> What Every C/C++ and Fortran developer Should Know!
> Read this article and learn how Intel has extended the reach of its
> next-generation tools to help Windows* and Linux* C/C++ and Fortran
> developers boost performance applications - including clusters.
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users