Re: [Bacula-users] Postgres Error

All,
OK. It looks like this issue has shown up before and is not critical:
http://old.nabble.com/regression-tests%3A-jobhisto_jobid_seq-td28277084.html

If anyone else runs into this in the future, the relevant commit is at 
the following link:
http://www.bacula.org/git/cgit.cgi/bacula/commit/?id=fe35ad03e0bff911ab8c7fcea9684bba83e3e9b9

I'm not sure why this commit never made it into bacula-client-5.0.3 from 
FreeBSD Ports though.

Mike


On 05/18/2011 11:16 AM, Mike Seda wrote:
> Hi Martin,
> It turns out that I do have a jobhisto table after all:
>
> bacula=> SELECT table_name FROM information_schema.tables WHERE 
> table_schema = 'public';
>    table_name
> ----------------
>  location
>  filename
>  path
>  file
>  mediatype
>  pool
>  storage
>  log
>  fileset
>  media
>  locationlog
>  jobhisto
>  pathhierarchy
>  unsavedfiles
>  basefiles
>  jobmedia
>  job
>  client
>  counters
>  version
>  cdimages
>  device
>  status
>  pathvisibility
> (24 rows)
>
> bacula=>
>
> Mike
>
>
> On 05/18/2011 10:46 AM, Mike Seda wrote:
>> 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

------------------------------------------------------------------------------
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