-----Original Message-----
From: C M Reinehr <cmr AT amsent DOT com>
Reply-to: bacula-users AT lists.sourceforge DOT net
To: bacula-users AT lists.sourceforge DOT net
Subject: Re: [Bacula-users] SQLite
Date: Wed, 29 Apr 2015 10:04:15 -0500
Mailer: KMail/1.13.7 (Linux/3.2.0-4-amd64; KDE/4.8.4; x86_64; ; )



On Wednesday, April 29, 2015 08:58:40 AM Matt Ivie wrote:

> -----Original Message-----

> From: Matt Ivie <matt.ivie AT bonntran DOT com>

> To: bacula-users AT lists.sourceforge DOT net

> Subject: [Bacula-users] SQLite

> Date: Mon, 27 Apr 2015 09:17:11 -0600

> Mailer: Evolution 3.2.3-0ubuntu6+6.0trisquel1

> 

> I saw a note in the Bacula documentation stating that some users were

> reporting database corruption problems when using SQLite. I also saw a

> thread on the mailing list from a couple of years ago where one user

> wanted to know if he would be better off using Postgresql

> 

> One user stated he had great luck using SQLite and another simply said

> he recommended Postgres. I don't want to run a full blown database if
I

> don't need to as my backup needs are not really complicated. I would

> like to use SQLite but if stability is a problem I'll have to rethink

> the situation and go with MySQL or Postgres.

> 

> Does anyone here have experience with using SQLite?

> 

> _______________________________________________

> Bacula-users mailing list

> Bacula-users AT lists.sourceforge DOT net

> https://lists.sourceforge.net/lists/listinfo/bacula-users

> 

> 

> Is there anyone with any experience on this issue?

> 

> For a little more background I'm going to be doing backups on machines

> with anywhere from 30GB to 230GB of storage used. I'm guessing that
the

> more files that get put into the tables the more possibility for

> corruption?

> 

> Any input on the topic is appreciated.

 

Matt,

 

I've been using SQLite for as long as I have used Bacula, perhaps
fourteen or fifteen years and have had zero problems. I have a small
operation with ten or twelve PC's (running Debian stable) and a couple
of servers. Disk backups are run nightly and a tape backup weekly. I've
read all the recommendations to run Postgres or MySQL but my philosophy
has been "if it ain't broke, don't fix it!" and just keep running
SQLite. It's easy to set up & manage, performance has not been a problem
and it doesn't tie up a lot of system resources.

 

Cheers!

 

CMR

 

-- 

Debian "Wheezy" Registered Linux User #241964

----

"In the first place we should insist that if the immigrant who comes
here in good faith becomes an American and assimilates himself to us, he
shall be treated on an exact equality with everyone else, for it is an
outrage to discriminate against any such man because of creed, or
birthplace, or origin. But this is predicated upon the man's becoming in
very fact an American, and nothing but an American." -- Theodore
Roosevelt

------

 

Thanks CMR for the information. I'm glad to hear of a real world
experience like this because it really is the proof that makes all the
difference. I agree with you, if it ain't broke don't fix it!

Matt


------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users