[Bacula-users] Bacula cannot create pools in PostgreSQL database

  Hello.

I cannot understand why bacula cannot fill my postgresql database tables.
I'm using CentOS 5.6 with bacula 5.0.3 and postgresql 8.1.23

When i'm try to backup some of my client i see follwoing :
19-Jul 17:18 bacula.petrsu.ru-dir JobId 3: No prior Full backup Job
record found.
19-Jul 17:18 bacula.petrsu.ru-dir JobId 3: No prior or suitable Full
backup found in catalog. Doing FULL backup.
19-Jul 17:18 bacula.petrsu.ru-dir JobId 3: Fatal error:
sql_create.c:211 sql_create.c:211 insert INSERT INTO Pool
(Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge)
VALUES 
('fullpool',0,5,0,1,0,1,1,15552000,0,40,0,268435456000,'backup',0,'fullvol-${Year}${Month:p/2/0/r}${Day:p/2/0/r}',0,0,1)
failed:
ERROR:  new row for relation "pool" violates check constraint
"pool_pooltype_check"

19-Jul 17:18 bacula.petrsu.ru-dir JobId 3: Fatal error: Pool
"fullpool" not in database. ERR=sql_create.c:213 Create db Pool record
INSERT INTO Pool
(Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge)
VALUES 
('fullpool',0,5,0,1,0,1,1,15552000,0,40,0,268435456000,'backup',0,'fullvol-${Year}${Month:p/2/0/r}${Day:p/2/0/r}',0,0,1)
failed: ERR=
19-Jul 17:18 bacula.petrsu.ru-dir JobId 3: Error: Bacula
bacula.petrsu.ru-dir 5.0.3 (30Aug10): 19-Jul-2011 17:18:50

# psql -WU bacula -d bacula -c \\dt
Password for user bacula:
             List of relations
 Schema |      Name      | Type  |  Owner
--------+----------------+-------+----------
 public | basefiles      | table | postgres
 public | cdimages       | table | postgres
 public | client         | table | postgres
 public | counters       | table | postgres
 public | device         | table | postgres
 public | file           | table | postgres
 public | filename       | table | postgres
 public | fileset        | table | postgres
 public | job            | table | postgres
 public | jobhisto       | table | postgres
 public | jobmedia       | table | postgres
 public | location       | table | postgres
 public | locationlog    | table | postgres
 public | log            | table | postgres
 public | media          | table | postgres
 public | mediatype      | table | postgres
 public | path           | table | postgres
 public | pathhierarchy  | table | postgres
 public | pathvisibility | table | postgres
 public | pool           | table | postgres
 public | status         | table | postgres
 public | storage        | table | postgres
 public | unsavedfiles   | table | postgres
 public | version        | table | postgres
(24 rows)

# psql -WU bacula -d bacula -c \\dp
Password for user bacula:
                               Access privileges for database "bacula"
 Schema |           Name            |   Type   |
Access privileges
--------+---------------------------+----------+-----------------------------------------------------
 public | basefiles                 | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | basefiles_baseid_seq      | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | cdimages                  | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | client                    | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | client_clientid_seq       | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | counters                  | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | device                    | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | device_deviceid_seq       | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | file                      | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | file_fileid_seq           | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | filename                  | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | filename_filenameid_seq   | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | fileset                   | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | fileset_filesetid_seq     | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | job                       | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | job_jobid_seq             | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | jobhisto                  | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | jobmedia                  | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | jobmedia_jobmediaid_seq   | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | location                  | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | location_locationid_seq   | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | locationlog               | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | locationlog_loclogid_seq  | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | log                       | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | log_logid_seq             | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | media                     | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | media_mediaid_seq         | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | mediatype                 | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | mediatype_mediatypeid_seq | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | path                      | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | path_pathid_seq           | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | pathhierarchy             | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | pathvisibility            | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | pool                      | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | pool_poolid_seq           | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | status                    | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | storage                   | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | storage_storageid_seq     | sequence |
{postgres=arwdRxt/postgres,bacula=rw/postgres}
 public | unsavedfiles              | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
 public | version                   | table    |
{postgres=arwdRxt/postgres,bacula=arwdRxt/postgres}
(40 rows)

------------------------------------------------------------------------------
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users