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
