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@lists.sourceforge.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@lists.sourceforge.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users