Bacula-users

Re: [Bacula-users] 2.2.8 inserting attributes taking a long time

2008-08-29 08:26:10
Subject: Re: [Bacula-users] 2.2.8 inserting attributes taking a long time
From: Michael Galloway <mgx AT ornl DOT gov>
To: Dan Langille <dan AT langille DOT org>
Date: Fri, 29 Aug 2008 08:26:02 -0400
On Thu, Aug 28, 2008 at 11:02:13PM -0400, Dan Langille wrote:
> Michael Galloway wrote:
> 
> http://www.bacula.org/en/rel-manual/Installi_Configur_PostgreS.html#PostgreSqlChapter
> 
>  From the above:
> 
> 
> "One way is to see if the PostgreSQL library that Bacula will be linked 
> against references pthreads. This can be done with a command such as:
> 
>    nm /usr/lib/libpq.a | grep pthread_mutex_lock
> 
> The above command should print a line that looks like:
> 
>           U pthread_mutex_lock
> 
> if does, then everything is OK. If it prints nothing, do not enable 
> batch inserts when building Bacula."
>

i have all of that:

from config.log:

  Batch insert enabled:       yes


and 

[root@molbio bacula-2.2.6]# nm /usr/local/pgsql/lib/libpq.a | grep 
pthread_mutex_lock
                 U pthread_mutex_lock


 
> side issue: I hope your database is SQL_ASCII, not UTF-8.
> 
> e.g.
> 
> $ psql -l | grep bacula
>   bacula                | bacula     | SQL_ASCII
> 
> Otherwise, you may encounter other problems later.
> 
> -------------------------------------------------------------------------
> 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
> 

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