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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
