On Jul 19, 2011, at 1:38 PM, Martin Simmons wrote:

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

Well spotted!

-- 
Dan Langille - http://langille.org


------------------------------------------------------------------------------
Storage Efficiency Calculator
This modeling tool is based on patent-pending intellectual property that
has been used successfully in hundreds of IBM storage optimization engage-
ments, worldwide.  Store less, Store more with what you own, Move data to 
the right place. Try It Now! http://www.accelacomm.com/jaw/sfnl/114/51427378/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users