On Wednesday, April 29, 2015 08:58:40 AM Matt Ivie wrote:
> -----Original Message-----
> From: Matt Ivie <matt.i...@bonntran.com>
> To: bacula-users@lists.sourceforge.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@lists.sourceforge.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
------
------------------------------------------------------------------------------
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
