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