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
