As I said, being a flat keyed system, sqlite will have sever performance problems, and eventually break due to the number of records written. If you backup a million files, you have just written a million records to the db.
I've been running for 3 weeks, and my postgresql db is 988 meg. Imagine that as a flat system lookup for each file to determine an incr backup selection Phil -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stanislav German-Evtushenko Sent: Friday, November 07, 2014 10:03 AM To: [email protected] Cc: [email protected] Subject: Re: [bareos-users] sqlite3 in production On Friday, November 7, 2014 5:57:31 PM UTC+3, [email protected] wrote: > Zitat von Stanislav German-Evtushenko <[email protected]>: > > > Does it make sense to talk about concurrency when it is accessed by > > the only process (bareos on our case) ? > > > > To my knowledge you have one db connection per running job and some > more for example per bconsole and the like, so yes concurrency could > also be a point to take care of. > > But as always YMMV > > Regards > > Andreas At the same time when you have the only single tape drive (means no concurrent jobs) and backups are only performed at non-working time it doesn't seem be a big issue for me. However documentation doesn't say "you can use sqlite3 in some cases", instead it says "only for testing". So I wonder if there are some serious issues with bareos/sqlite3 that we should know about. -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout. This message (including any attachments) may contain confidential, proprietary, privileged and/or private information. The information is intended to be for the use of the individual or entity designated above. If you are not the intended recipient of this message, please notify the sender immediately, and delete the message and any attachments. Any disclosure, reproduction, distribution or other use of this message or any attachments by an individual or entity other than the intended recipient is prohibited. -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
