Bacula-users

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

2008-08-29 11:23:03
Subject: Re: [Bacula-users] 2.2.8 inserting attributes taking a long time
From: Dan Langille <dan AT langille DOT org>
To: Michael Galloway <mgx AT ornl DOT gov>
Date: Fri, 29 Aug 2008 11:22:45 -0400
Michael Galloway wrote:
> 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

Then it must be something else.

I've lost track of the rest of the thread.

Check your disk IO and see if it's active.  Check your database, see if 
it's active.  For PostgreSQL, start with:

select * from pg_activity_stat;

Assuming activity stats is enabled...


-- 
Dan Langille

BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
PGCon  - The PostgreSQL Conference:     http://www.pgcon.org/

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