Hello,

The batch mode improve the speed with postgresql by a factor of 10 (maybe
20), using
a very big job (15M files) with the standard mode won't work too.

But, you will be able to cancel the job because the director checks the job
status  between each insertion. With the batch mode, you have a single query
for 15M files.

To stop the job, you can cancel the postgresql query with
pg_cancel_backend() with your psql. The query will be canceled and the job
will stop. 

Bye


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

-- 
View this message in context: 
http://www.nabble.com/Hung-on-%22Dir-inserting-attributes%22-tp20450040p20456410.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


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