Oh, I see now -- CREATE TABLE JobHisto (LIKE Job) doesn't create a sequence (and it isn't wanted).
__Martin >>>>> On Wed, 18 May 2011 12:05:18 -0700, Mike Seda said: > > 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 > ------------------------------------------------------------------------------ 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
