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. :) > >> >>> 2) else since the update, i have a client with a state of "dir >>> inserting attribute" for 3 hours :( >>> This Client have 1,8 To and 16 Millions of files. An idea if >>> something >>> change since ?? >> >> That's a lot of inserts to do. It can take a while to insert 16 >> million rows. >> >>> >>> No grant privileges on Tables restoreobject* , like this urls say ( >>> >>> >>> http://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg51149.html >>> >>> ) >> >> I'm not sure why you mention this... :) > these are things that I could etrangent notes for the update... > Not important ? ... I don't know. >> >>> >>> everything works well apart this status "DIR inserting attribute" >>> for >>> one big client and libpq.a not installed. I'm a little worried. >> >> Are you sure that libpq.a is not installed? Please check again... > In prod, i very sure. >> >>> >>> Thank for any information. >> >> > I search ... I found a notion of "Spool attributes" ?? It sounds like your system is already spooling attributes. Perhaps if you pasted your Job and JobDefs (if applicable) for the Job in question. -- Dan Langille - http://langille.org/ ------------------------------------------------------------------------------ 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
