Re: [Bacula-users] Poll - What operating systems do you run Bacula on?

2006-10-19 Thread Karl Hakimian
Gentoo linux 5 systems. -- Karl Hakimian - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere

Re: [Bacula-users] Listing filenames of backed up files

2006-02-23 Thread Karl Hakimian
On Thu, Feb 23, 2006 at 10:58:03AM +0100, Geir Asle Borgen wrote: > On Wed, 2006-02-22 at 06:54 -0800, Karl Hakimian wrote: > > On Wed, Feb 22, 2006 at 02:58:11PM +0100, Geir Asle Borgen wrote: > > > OK, but I'm no SQL guru ... I'm capable to get in to query-mode (using

Re: [Bacula-users] Postgres speed

2006-02-23 Thread Karl Hakimian
ideas too, but I did not want to air them until I had been through the code enough to know what I was talking about. -- Karl Hakimian [EMAIL PROTECTED] --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that exten

Re: [Bacula-users] Listing filenames of backed up files

2006-02-22 Thread Karl Hakimian
app, I'd suggest sticking with bconsole. -- Karl Hakimian [EMAIL PROTECTED] --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your

Re: [Bacula-users] Postgres speed

2006-02-10 Thread Karl Hakimian
d updating paths and filenames (I'm thinking of the case where the attributes are spooled) in a case like this, your large number of adds to the file table will not need anything that gets added to the path or filename table after you st

Re: [Bacula-users] Postgres speed

2006-02-10 Thread Karl Hakimian
On Fri, Feb 10, 2006 at 07:22:10AM -0800, Karl Hakimian wrote: > On Fri, Feb 10, 2006 at 10:12:10AM -0500, Dan Langille wrote: > > If you have concurrent jobs, what happens when job #1 wants to add a > > file to the table, and job #2 wants to add the same file? How do you >

Re: [Bacula-users] Postgres speed

2006-02-10 Thread Karl Hakimian
possible problem, but if you don't supply the field, postgres will set it to the default which will be correctly setting it from the sequence. -- Karl Hakimian [EMAIL PROTECTED] --- This SF.net email is sponsored by: Splunk Inc. Do you gr

Re: [Bacula-users] Postgres speed

2006-02-10 Thread Karl Hakimian
On Fri, Feb 10, 2006 at 03:12:24PM +, Martin Simmons wrote: > Because it was tied to multiple connections and this made it fatally broken > because of how the filename and path tables are updated. Could you elaborate on the problem? Multiple connections from where? -- Karl Hakimian

Re: [Bacula-users] Postgres speed

2006-02-10 Thread Karl Hakimian
ibutes. > I think transactions are more important here. We need to look more > closely at that. I believe transactions would help quite a bit. Seems to me I saw some transaction code in bacula commented out. Does anyone know why it was rem

Re: [Bacula-users] Limiting FD file views???

2006-02-09 Thread Karl Hakimian
f down sides, each catalog will need it's own tapes. There is a bug in bconsole that connects to the original database even if it is blocked by an acl. -- Karl Hakimian [EMAIL PROTECTED] --- This SF.net email is sponsored by: Splunk Inc.

Re: [Bacula-users] migrating to different database backend

2006-02-03 Thread Karl Hakimian
M > ANALYZE then. Good suggestion. I was wondering if that was a better way to deal with this particular database. -- Karl Hakimian [EMAIL PROTECTED] --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for pr

Re: [Bacula-users] migrating to different database backend

2006-02-03 Thread Karl Hakimian
had quite an unexpected result. The query runs fast enough under the new database while still running slowly on the old one. I am running pg_autovacuum (and I ran one by hand recently to see if that would help) so I'm surprised that re-creating the database would make this kind of differen

Re: [Bacula-users] migrating to different database backend

2006-02-03 Thread Karl Hakimian
ht forward using standard sql references. The changes needed to make the query work with mysql just about drive me nuts. -- Karl Hakimian [EMAIL PROTECTED] --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for

Re: [Bacula-users] Re: bacula restores

2006-02-02 Thread Karl Hakimian
the memory tree. By changing bacula to retrieve the result row at a time instead of all at once, it took only 650M and 5 less minutes (no swapping) to build the tree. As soon as I put together a patch, I will post it to the developers list and see if it can get incorporated into the official so

Re: [Bacula-users] Gentoo-ebuild bacula 1.38.x

2006-01-26 Thread Karl Hakimian
e this: > > http://dev.gentoo.gr.jp/~trombik/portage/app-backup/bacula/ According to this bug report http://bugs.gentoo.org/show_bug.cgi?id=111677 Someone should be putting the new version into portage this weekend. -- Karl Hakimian [EMAIL PROTECTED] -