On Nov 17, 2008, at 4:03 PM, Pascal Clermont wrote:

> Hi,
> Currently spending a lot of time on improving the speeds of this  
> network.
> After several tests I have realized that the database is "inserting
> attributes" was taking quite a lot of time. In order to improve this I
> have searched your forums and see that using batch mode would increase
> this action by 10 times. The guide states:
> " 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 file /usr/lib/libpq.a does not exist, I am using postgreSQL 8.3.5
> and did not install from source, but from the package manager that  
> comes
> with the OS, YUM.

The problem with operating systems is they each think theirs is the  
file layout.

Experiment a little, and you'll find it.  Mine, on FreeBSD, is here:

$  nm /usr/local/lib/libpq.a | grep pthread_mutex_lock
          U pthread_mutex_lock
          U pthread_mutex_lock


>
>
> Would someone know how I can find out if thread safety is on without
> breaking everything?
> AND if it is on, will Batch Insert Code from bacula work anyways?  
> since
> the file it links against "/usr/lib/libpq.a" is not existent.

I'm sure you have libpq.a

Just keep in mind that location varies.

>
>
>
> Pascal S. Clermont
>
> -------------------------------------------------------------------------
> 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

-- 
Dan Langille
http://langille.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