Bacula-users
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

Re: [Bacula-users] Postgres Error

2011-05-18 14:18:54
Subject: Re: [Bacula-users] Postgres Error
From: Mike Seda <maseda AT stanford DOT edu>
To: bacula-users AT lists.sourceforge DOT net
Date: Wed, 18 May 2011 11:16:21 -0700 
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
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  [Bacula-users] [SOLVED] OneFS = no doesn't work, Roy Sigurd Karlsbakk
Next by Date:  Re: [Bacula-users] [Bacula-devel] [SOLVED] OneFS = no doesn't work, Kern Sibbald
Previous by Thread:  Re: [Bacula-users] Postgres Error, Mike Seda
Next by Thread:  Re: [Bacula-users] Postgres Error, Mike Seda
Indexes:  [Date] [Thread] [Top] [All Lists]