On Wed, Nov 12, 2008 at 01:45:46AM +0200, Jari Fredriksson wrote:
> 
> You might want to configure and compile your bacula with
> 
>      --enable-batch-insert=no
> 
> configure option. While that option (default=yes) is supposed to fasten 
> backups, I have to set it to no, or every job will hang indefinitely to that 
> same sql statement.
> 
> I have only 256M ram in this machine, which may be a reason, but anyway. It 
> that is "no" the job may take a bit longer to finish, but it will finish 
> anyway.

Very good answer.  I'll check with our DBA to see what can be done with
PostgreSQL to make sure we have enough resources for batch inserts.  If
that doesn't help, I'll rebuild with batch inserts disabled (although
I'd rather not).

Thanks, 

-- 
Jason Dixon
OmniTI Computer Consulting, Inc.
jdixon AT omniti DOT com
443.325.1357 x.241

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users