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? > 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... :) > > 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... > > Thank for any information. -- 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