>>>>> On Thu, 29 Nov 2012 08:51:36 -0500, Dan Langille said: > > On 2012-11-29 08:34, Olivier Delestre wrote: > > Le 29/11/2012 13:55, Dan Langille a écrit : > >> On 2012-11-29 07:38, Olivier Delestre wrote: > >>> Hi, > >>> > >>> I upgrade bacula 5.0.3 ( psql 8.4 ) to 5.2.5 ( psql 9.1 ) on > >>> ubuntu > >>> 12.04.1 LTS. > >>> > >>> I asked about : > >>> > >>> 1) The documentation of bacula that saying : > >>> > >>> "If you configure the Batch Insert code in Bacula (attribute > >>> inserts > >>> are > >>> 10 times faster), you MUST be using a PostgreSQL that was built > >>> with > >>> the --ENABLE-THREAD-SAFETY option, otherwise you will get > >>> DATA CORRUPTION. Most major Linux distros have thread safety turned > >>> on, but > >>> it is better to check. 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 " > >>> > >>> But, no such file. What is its usefulness ? > >> > >> Different operating systems install this file in different places. > >> Here is > >> how I found it on a FreeBSD system: > >> > >> $ locate libpq.a > >> /usr/local/lib/libpq.a > >> > >> And running the command: > >> > >> $ nm /usr/local/lib/libpq.a | grep pthread_mutex_lock > >> U pthread_mutex_lock > >> U pthread_mutex_lock > >> > >> > >>> i found it by installing postgresql-server-dev-9.1. Not installed > >>> from > >>> scratch install or upgrade... > >>> > >>> I think the package bacula 5.2.5 is compiled with > >>> enable-batch-insert > >>> and postgresql 5.2.5 with enable-thread-safety ( obtain source > >>> package > >>> with apt-get source xxx ) > >> > >> Do you have any unanswered questions? > > > > I found /usr/lib/libpq.a if i installed postgresql-server-dev-9.1 on > > my test machine. what use is it ? > > I'm sorry, but I don't know for sure. I'm sure it is used by that > package. :)
The Bacula documentation assumes static libraries (.a), but Linux distros typically don't install them by default. In some Linux distros, the static libraries are in the dev(el) package. I suspect Olivier has /usr/lib/libpq.so* instead, so objdump -T /usr/lib/libpq.so* | grep pthread_mutex_lock should be check instead. -- Martin Simmons LispWorks Ltd http://www.lispworks.com/ ------------------------------------------------------------------------------ Keep yourself connected to Go Parallel: VERIFY Test and improve your parallel project with help from experts and peers. http://goparallel.sourceforge.net _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
