On 16/01/2021 07:16, Ken Johnson wrote:
Thanks for the helpful advice. It sounds like an issue with timestamp
translation, though I am far from a database expert.
I am working on the same approach, pgloader to postgresql. I do not do
incrementals, so that particular issue will not be a probl
: Wednesday, January 13, 2021 5:46 PM
To: bacula-users
Subject: Re: [Bacula-users] sqlite to postgres|maridb migration -- how to
confirm success?
Migrating from SQLite to Postgres seems to be hard to get right. There doesn't
appear to be any reliable, officially sanctioned way to do it. I did
> Sent: Tuesday, December 22, 2020 6:04 PM
> To: bacula-users@lists.sourceforge.net
> Subject: [Bacula-users] sqlite to postgres|maridb migration -- how to
> confirm success?
>
> Hello,
>
> I am facing the sqlite to postgres or mariadb (mysql) migration of the
> Bacula
For the benefit of anyone who reads this thread later, see dbcheck, provided
as part of bacula.
Ken
-Original Message-
From: Ken Johnson [mailto:kjohn...@eclypse.org]
Sent: Tuesday, December 22, 2020 6:04 PM
To: bacula-users@lists.sourceforge.net
Subject: [Bacula-users] sqlite to
On 12/23/20 11:00 AM, Sebastian Suchanek wrote:
> Am 23.12.2020 um 05:21 schrieb Gary R. Schmidt:
>
>> [...]
>> I would suggest moving to PostgreSQL rather than MariaDB.
>>
>> PostgreSQL is fully supported by Bacula, MariaDB has thrown up a few
>> nasties where is is not quite the same as MySQL,
Am 23.12.2020 um 05:21 schrieb Gary R. Schmidt:
> [...]
> I would suggest moving to PostgreSQL rather than MariaDB.
>
> PostgreSQL is fully supported by Bacula, MariaDB has thrown up a few
> nasties where is is not quite the same as MySQL, and those will probably
> increase.
> [...]
Just out o
On 23/12/2020 11:03, Ken Johnson wrote:
Hello,
I am facing the sqlite to postgres or mariadb (mysql) migration of the
Bacula database. The current db file is about 5GB, after a vacuum. Right
now I think I will choose the one with the best migration tools I can get
for it. Otherwise, I do not
Hello,
I am facing the sqlite to postgres or mariadb (mysql) migration of the
Bacula database. The current db file is about 5GB, after a vacuum. Right
now I think I will choose the one with the best migration tools I can get
for it. Otherwise, I do not know of a reason to care. I have done mor
Hello Suzy
There is a script in source bacula examples, but I'm not sure if it work.
Is interesting to read the chapter "Catalog Maintence" of manual
www.bacula.org/7.4.x-manuals/en/main/main.pdf
Best Regards
Atenciosamente
*Wanderlei Hüttel*
http://www.huttel.com.br
2016-03-11 10:38 GMT-03:
I will find some documentation about upgrading to postgre. Maybe you have so
tips?
Thank you
+--
|This was sent by andrej.haupt...@apek.si via Backup Central.
|Forward SPAM to ab...@backupcentral.com.
+---
Sqlite is not supported anymore in newer version of Bacula.
Please upgrade for MySQL or Postgres
Atenciosamente
*Nome **|* *Wanderlei Hüttel*
http://www.huttel.com.br
2016-03-11 7:27 GMT-03:00 Suzy :
> If i do:
> sqlite /var/lib/bacula/bacula.db
>
> I get:
> Unable to open database "/var/lib/
If i do:
sqlite /var/lib/bacula/bacula.db
I get:
Unable to open database "/var/lib/bacula/bacula.db": file is encrypted or is
not a database
but if I do:
sqlite3 /var/lib/bacula/bacula.db
it connects fine.
It used to work for both scenarios. Can you tell how can I fix sqlite to work
too?
+---
-Original Message-
From: Dimitri Maziuk
To: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] SQLite
Date: Wed, 29 Apr 2015 10:12:53 -0500
Mailer: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101
Thunderbird/31.6.0
On 2015-04-29 08:58, Matt Ivie wrote:
>
-Original Message-
From: C M Reinehr
Reply-to: bacula-users@lists.sourceforge.net
To: bacula-users@lists.sourceforge.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
On Wednesday, April 29, 2015 08:58:40 AM Matt Ivie wrote:
> -Original Message-
> From: Matt Ivie
> 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
>
On 2015-04-29 08:58, Matt Ivie wrote:
> Any input on the topic is appreciated.
http://www.sqlite.org/howtocorrupt.html
The size of the database is determined by the number of files and
retention periods. IRL the most likely corruption scenario is the disk
going bad, so size doesn't matter. Whe
-Original Message-
From: Matt Ivie
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
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 l
On 26/02/2011 11:50 AM, Dan Langille wrote:
> On 2/25/2011 10:54 AM, C M Reinehr wrote:
>> On Thu 24 February 2011 07:27:48 pm Dan Langille wrote:
>>> On 2/24/2011 10:08 AM, C M Reinehr wrote:
On Wed 23 February 2011 10:30:11 pm Dan Langille wrote:
> A recent bug report (http://bugs.bacula
On 2/25/2011 10:54 AM, C M Reinehr wrote:
> On Thu 24 February 2011 07:27:48 pm Dan Langille wrote:
>> On 2/24/2011 10:08 AM, C M Reinehr wrote:
>>> On Wed 23 February 2011 10:30:11 pm Dan Langille wrote:
A recent bug report (http://bugs.bacula.org/view.php?id=1688) which
indicated that w
On Thu 24 February 2011 07:27:48 pm Dan Langille wrote:
> On 2/24/2011 10:08 AM, C M Reinehr wrote:
> > On Wed 23 February 2011 10:30:11 pm Dan Langille wrote:
> >> A recent bug report (http://bugs.bacula.org/view.php?id=1688) which
> >> indicated that we are no longer supporting SQLite.
> >>
> >>
Am 24.02.2011 16:08, schrieb C M Reinehr:
> On Wed 23 February 2011 10:30:11 pm Dan Langille wrote:
>> A recent bug report (http://bugs.bacula.org/view.php?id=1688) which
>> indicated that we are no longer supporting SQLite.
>>
>> I feel it's safe to stop regression testing against it.
> I'm sorry
On 2/24/2011 10:08 AM, C M Reinehr wrote:
> On Wed 23 February 2011 10:30:11 pm Dan Langille wrote:
>> A recent bug report (http://bugs.bacula.org/view.php?id=1688) which
>> indicated that we are no longer supporting SQLite.
>>
>> I feel it's safe to stop regression testing against it.
>
> I'm sorr
On Wed 23 February 2011 10:30:11 pm Dan Langille wrote:
> A recent bug report (http://bugs.bacula.org/view.php?id=1688) which
> indicated that we are no longer supporting SQLite.
>
> I feel it's safe to stop regression testing against it.
I'm sorry to hear that. I've been using SQLite for the enti
A recent bug report (http://bugs.bacula.org/view.php?id=1688) which
indicated that we are no longer supporting SQLite.
I feel it's safe to stop regression testing against it.
--
Dan Langille - http://langille.org/
--
F
Hi John,
On Fri, 21 Aug 2009, John Goerzen wrote:
> Over at Debian, we received a bug report at
> http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=542810 regarding the
> migration from sqlite2 to sqlite3. We are doing the process implied
> by the make_catalog_backup command; namely:
Did you fin
Hi folks,
Over at Debian, we received a bug report at
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=542810 regarding the
migration from sqlite2 to sqlite3. We are doing the process implied
by the make_catalog_backup command; namely:
sqlite "$DB" .dump | sqlite3 "$DB.sqlite3"
Our reporter
>> >> I have bacula 2.0.3 installed with sqlite on a machine that also
>> >> has mysql on it
>> >> for some reason when the bacula works, mysql has trouble working.
>> >
>> > Please define "has trouble working".
>
>> When you say "has trouble working", what do you mean?
>
> mysql queries get stuck
Hi, I'm trying to get Bacula 2.0.3 up and running on a 64-bit server
running CentOS5. I installed using the rpm packages, and ran the
database initialization scripts as indicated, but when I try to start
the director, I get the following message:
Starting the Bacula Director daemon
03-Aug 12:3
mysql queries get stuck when bacula start working.
- Original Message -
From: "Dan Langille" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: יום שישי 03 אוגוסט 2007 17:20
Subject: Re: [Bacula-users] sqlite and mysql
On 3 Aug 2007 at 17:15, [
On 3 Aug 2007 at 17:15, [EMAIL PROTECTED] wrote:
> - Original Message -
> From: "Dan Langille" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc:
> Sent: 03 2007 08:30
> Subject: Re: [Bacula-users] sqlite and mysql
>
>
> > On 3 A
Trustix 2.2
- Original Message -
From: "Dan Langille" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: יום שישי 03 אוגוסט 2007 08:30
Subject: Re: [Bacula-users] sqlite and mysql
> On 3 Aug 2007 at 6:48, [EMAIL PROTECTED] wrote:
>
>> I have bacul
On 3 Aug 2007 at 6:48, [EMAIL PROTECTED] wrote:
> I have bacula 2.0.3 installed with sqlite on a machine that also has
> mysql on it
>
> for some reason when the bacula works, mysql has trouble working.
Please define "has trouble working".
> any suggestions?
What OS are you using?
--
Dan La
I have bacula 2.0.3 installed with sqlite on a machine that also has mysql
on it
for some reason when the bacula works, mysql has trouble working.
any suggestions?
-
This SF.net email is sponsored by: Splunk Inc.
Still grep
Hello List
Lately i migrated the database of bacula from sqlite to mysql using a
sample script i've found in the cvs repo.
now running the first backup i get the following warnings:
--8<--
13-Jul 09:37 calculon-dir: Calculon_Full_Backup.2006-07-13_08.27.54
Warning: sql_create.c:831 More than one F
Chris Hunter wrote:
Hi,
I am running bacula 1.38.4 on Scientifc Linux, a rhel4 clone. I am using
sqlite3 for my database. My catalog has roughly 200K files; I backup
approx 500GB weekly.
Question #1: is 200,000 files too big a catalog for sqlite ?
I ask because, the one restore job I have d
Hi,
I am running bacula 1.38.4 on Scientifc Linux, a rhel4 clone. I am using
sqlite3 for my database. My catalog has roughly 200K files; I backup
approx 500GB weekly.
Question #1: is 200,000 files too big a catalog for sqlite ?
I ask because, the one restore job I have done was nearly 7 hours
While browsing the SQLite docs, to see how to find out what indices are
on a table ( the answer is '.schema ' ), I came across this.
Kern, perhaps this is why SQLite 3.0 seems so slow for you?
PRAGMA synchronous;
PRAGMA synchronous = FULL; (2)
PRAGMA synchronous = NORMAL; (1)
PRAGMA synchronous =
Hello,
I've run Director handling the Database with SQLITE 2.8.1x. Database is
about 1.7 gigabytes in size.
Performance is a bit slow, when pruning, building job tree.
Before moving to Mysql 4.1 :
May I expect a noticeable performance improvment using MySQL in local mode
?
Had someone experime
On Wed, Jul 06, 2005 at 04:31:54PM -0400, Tony Niemetz wrote:
> If anyone besides Phil was following this I found the problem, thought
> I'd post it up. It was not a bacula problem but, someone may run in to
> this at some point:
Glad you found the problem, and that it was a minor "oops" not an "O
Hi,
Tony Niemetz wrote:
If anyone besides Phil was following this I found the problem, thought
I'd post it up. It was not a bacula problem but, someone may run in to
this at some point:
-My backups all go to file storage on a remote storage server
-I auto mount (via fstab) the storage server t
lem solved. Now I have to find my brain...
Tony Niemetz
-Original Message-
From: Tony Niemetz
Sent: Wednesday, July 06, 2005 2:56 PM
To: Phil Stracchino
Cc: Bacula users
Subject: RE: [Bacula-users] SQLite DB Size
df -h results:
40G 40G 0 100% /
I can only find about 3G-4G o
come.
Tony Niemetz
-Original Message-
From: Phil Stracchino [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 06, 2005 2:46 PM
To: Tony Niemetz
Cc: Bacula users
Subject: Re: [Bacula-users] SQLite DB Size
On Wed, Jul 06, 2005 at 02:36:53PM -0400, Tony Niemetz wrote:
> The symptom was
On Wed, Jul 06, 2005 at 02:36:53PM -0400, Tony Niemetz wrote:
> The symptom was the jobs failing. After poking around it looks like the
> partition bacula is in ( / by the way ) is reporting full. It's a 40G
> partition reporting that it is 100% in use. I mistakenly thought the
> catalog was fillin
On Wed, Jul 06, 2005 at 02:11:33PM -0400, Tony Niemetz wrote:
> My apologies to the list...I was thinking one thing and looking at
> another. I have no idea where I came up with the 80G catalog number (I
> must have been thinking of the actual data stored). I have a 40G
> partition on the director
1:51 PM
To: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] SQLite DB Size
On Wed, Jul 06, 2005 at 01:44:57PM -0400, Tony Niemetz wrote:
> Bacula Version: 1.36.3
> DB: SQLite
>
> I installed and have been using Bacula successfully for about 4 weeks
> now. I chose the SQLi
On Wed, Jul 06, 2005 at 01:44:57PM -0400, Tony Niemetz wrote:
> Bacula Version: 1.36.3
> DB: SQLite
>
> I installed and have been using Bacula successfully for about 4 weeks
> now. I chose the SQLite database. The database, after these 4 weeks, has
> grown to 80G in size.
80GB of catalog in four
Title: SQLite DB Size
Bacula Version: 1.36.3
DB: SQLite
I installed and have been using Bacula successfully for about 4 weeks now. I chose the SQLite database. The database, after these 4 weeks, has grown to 80G in size. At this rate it will not take long to get out of hand. This is my firs
Hello all,
On a fresh install of bacula, the following leads to a crash :
- do some backup
- edit bacula-dir.conf to add some files
- restart bacula-dir
results in this error (seen from bconsole):
*status dir
Using default Catalog name=MyCatalog DB=bacula
Could not open database "bacula".
sqlit
On Sat, 9 Apr 2005 6:07 am, Pedro Lobo S. da Rocha wrote:
> Hi,
>
>
> I need to restart my catalog, i'm using sqlite and i don't have the
> drop_sqlite_tables script.
>
> Thanks!
delete /var/bacula/bacula.db
the scripts just checks for the existence of this file and deletes it if it
exists, oth
Hi,
I need to restart my catalog, i'm using sqlite and i don't have the drop_sqlite_tables script.
Thanks!
51 matches
Mail list logo
