|
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
------
| 