>>>>> On Tue, 19 Jul 2011 17:36:51 +0400, Igor Zinovik said:
> 
>   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"

Check your Pool definition in bacula-dir.conf -- it looks like you have 

Pool Type = backup

If so, change it to

Pool Type = Backup

i.e. capital B.

__Martin

------------------------------------------------------------------------------
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