Thank you guys!
I will look into it and write back when I have some
result.
--
George
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Hello Georg!
These scripts were based in the manual chapter "*Converting from MySQL to
PostgreSQL*"
http://www.bacula.org/9.2.x-manuals/en/main/Installing_Configuring_Post.html#SECTION00445
I've converted my Bacula database (about 1gb a year ago) and I help another
community user
Wonderlei knows Bacula well and does good work, so I imagine his script
could work well. However, I have not personally used it. I have asked
to get a copy of the Bacula Systems script, but all the key players are
currently on vacation.
I recommend that you try it. You can have both MySQL a
On Tue, 7 Aug 2018 14:45:15 -0300 Wanderlei Huttel
wrote:
> If somebody wants to migrate from MySQL to
> PostgreSQL I've created a script to simplify this.
> https://github.com/wanderleihuttel/bacula-utils/tree/master/convert_mysql_to_postgresql
Thanks for sharing!
Kern, could you please have a
> On Tue, 7 Aug 2018 13:14:00 -0400, Phil Stracchino said:
>
> On 08/07/18 08:27, Martin Simmons wrote:
> >> On Mon, 6 Aug 2018 20:13:17 -0400, Phil Stracchino said:
> >>
> >> On 08/06/18 20:05, George Anchev via Bacula-users wrote:
> >>> Today I installed 9.2.0 FD on one of the network
>
If somebody wants to migrate from MySQL to PostgreSQL I've created a script
to simplify this.
https://github.com/wanderleihuttel/bacula-utils/tree/master/convert_mysql_to_postgresql
Best regards
*Wanderlei Hüttel*
http://www.bacula.com.br
Em ter, 7 de ago de 2018 às 14:33, Kern Sibbald escreve
I have already done it for the make_mysql_tables.in script, but I need
to modify the update_mysql_tables.in to add the new defaults.
On 08/07/2018 04:22 PM, Martin Simmons wrote:
On Tue, 7 Aug 2018 15:49:07 +0200, Kern Sibbald said:
By the way, after switching, I have had zero problems with Po
On 08/07/18 08:27, Martin Simmons wrote:
>> On Mon, 6 Aug 2018 20:13:17 -0400, Phil Stracchino said:
>>
>> On 08/06/18 20:05, George Anchev via Bacula-users wrote:
>>> Today I installed 9.2.0 FD on one of the network
>>> workstations. Trying to run an estimate for an
>>> incremental job tells m
> On Tue, 7 Aug 2018 15:49:07 +0200, Kern Sibbald said:
>
> By the way, after switching, I have had zero problems with PostgreSQL.
Since Bacula works fine with NULL in these datetime fields (NULL is the
implicit default in PostgreSQL), should the MySQL schema be changed to say
'DEFAULT NULL'
Hello,
I originally started with MySQL, so know it well, but over the years, I
realized that PostgreSQL performed better for larger type backups (500
or more clients) or bigger catalogs, so I switched from MySQL to PostgreSQL.
It was a bit painful because the first user generated script I use
> On Mon, 6 Aug 2018 20:13:17 -0400, Phil Stracchino said:
>
> On 08/06/18 20:05, George Anchev via Bacula-users wrote:
> > Today I installed 9.2.0 FD on one of the network
> > workstations. Trying to run an estimate for an
> > incremental job tells me that "Job 0" cannot find
> > previous Ful
On Tue, 7 Aug 2018 11:24:36 +0200 Kern Sibbald wrote:
> Right at the moment, I don't recommend using
> MariaDB. They are just now fixing a very serious
> false deadlock detection bug that causes Bacula to
> fail.
Thanks for the info Kern.
In this case:
How can I migrate my catalog to PostgreSQ
George,
Right at the moment, I don't recommend using MariaDB. They are just
now fixing a very serious false deadlock detection bug that causes
Bacula to fail.
= Copy paste from a recent email =
[ https://jira.mariadb.org/brow
On Tue, 7 Aug 2018 11:43:37 +1000 Gary R. Schmidt
wrote:
> Your problem is that you have broken the version
> rule FD =< (SD == DIR).
Currently:
Host 1: SD=DIR=FD version = 9.2.0
Host 2: FD version = 9.2.0
> Update your director(s) and storage daemon(s) first.
Considering the above - is there
On 07/08/2018 10:05, George Anchev via Bacula-users wrote:
Today I installed 9.2.0 FD on one of the network
workstations. Trying to run an estimate for an
incremental job tells me that "Job 0" cannot find
previous Full backup, so it will estimates a full one.
My workaround with changing the SQL_
Thanks for the quick response Phil.
On Mon, 6 Aug 2018 20:13:17 -0400 Phil Stracchino
wrote:
> You probably need to go through each table and
> change any field (except BLOB or TEXT) that is
> declared NOT NULL without a DEFAULT to 'DEFAULT
> NULL'.
Is there a command which does that or should I
On 08/06/18 20:05, George Anchev via Bacula-users wrote:
> Today I installed 9.2.0 FD on one of the network
> workstations. Trying to run an estimate for an
> incremental job tells me that "Job 0" cannot find
> previous Full backup, so it will estimates a full one.
>
> My workaround with changing
Today I installed 9.2.0 FD on one of the network
workstations. Trying to run an estimate for an
incremental job tells me that "Job 0" cannot find
previous Full backup, so it will estimates a full one.
My workaround with changing the SQL_MODE didn't work
in this case.
On Mon, 6 Aug 2018 16:37:02 -
On 08/06/18 15:32, Tilman Schmidt wrote:
> Am 02.08.2018 um 23:47 schrieb Phil Stracchino:
>>>
>>> Minimal fix:
>>
>> ALTER TABLE Media MODIFY FirstWritten datetime DEFAULT NULL;
>
> Thanks. I extended that to:
>
> ALTER TABLE Media MODIFY FirstWritten datetime DEFAULT NULL;
> ALTER TABLE Media
Am 02.08.2018 um 23:47 schrieb Phil Stracchino:
>>
>> Minimal fix:
>
> ALTER TABLE Media MODIFY FirstWritten datetime DEFAULT NULL;
Thanks. I extended that to:
ALTER TABLE Media MODIFY FirstWritten datetime DEFAULT NULL;
ALTER TABLE Media MODIFY LastWritten datetime DEFAULT NULL;
ALTER TABLE
On 08/02/18 17:19, Tilman Schmidt wrote:
> Alright, here's the details I promised:
>
> openSUSE Leap 42.3
> mysql-community-server 5.6.40-36.1
> Bacula 9.0.8-1.1 from extra repo obs://build.opensuse.org/home:cristyde
>
> The error:
>
> Sending relabel command from "Oktober-2" to "Nessy" ...
> 30
Alright, here's the details I promised:
openSUSE Leap 42.3
mysql-community-server 5.6.40-36.1
Bacula 9.0.8-1.1 from extra repo obs://build.opensuse.org/home:cristyde
The error:
Sending relabel command from "Oktober-2" to "Nessy" ...
3000 OK label. VolBytes=64512 VolABytes=0 VolType=0 Volume="Nes
Hi,
First: thanks to everyone who stepped in and shared
thoughts and info.
Another person who replied to me directly (not through
the mailing list) helped very much with this by
sharing what he was also helped with previously. Here
is the info:
BACKGROUND
> This is correct, it is not a Mar
On 08/02/18 10:39, Tilman Schmidt wrote:
> Just a quick note to help narrowing this down:
> * I'm experiencing this "Field 'StartTime' doesn't have a default value"
> error on an openSUSE installation ever since it was upgraded to Leap 42.3 and
> Bacula 9.
> * The machine in question runs MySQL,
Just a quick note to help narrowing this down:
* I'm experiencing this "Field 'StartTime' doesn't have a default value" error
on an openSUSE installation ever since it was upgraded to Leap 42.3 and Bacula
9.
* The machine in question runs MySQL, not MariaDB, even though openSUSE has
deprecated M
Hello,
Maybe you can get some help from the list or from bacula-devel. At this
time, I am not yet equipped or ready to start trying to support
MariaDB. It will happen sometime, but not just now. One of the big
problems for me is that it seems it is impossible (at least on Ubuntu)
to have b
On Wed, 1 Aug 2018 12:59:43 +0200 Kern Sibbald
wrote:
> Please note that we do not officially support
> MariaDB -- one prior version has some serious
> problems falsely detecting deadlocks. Bacula works
> perfectly well with all "out of the box"
> installations of MySQL.
>
> Concerning the error
Please note that we do not officially support MariaDB -- one prior
version has some serious problems falsely detecting deadlocks. Bacula
works perfectly well with all "out of the box" installations of MySQL.
Concerning the error message you are getting, either this is a MariaDB
problem or you
After some searching I found this:
http://bacula.10910.n7.nabble.com/Bacula-9-0-0-StartTime-doesn-t-have-a-default-value-td86055.html
My situation is quite similar to that of the OP as I
am also using openSUSE (Leap 15.0) and MariaDB:
MariaDB [(none)]> show variables like "%version%";
+-
So... after successfully building Bacula 9.2.0 and
running all 3 daemons, backup doesn't work. Mounting a
tape and running the regular job which I have been
running for years now gives me:
01-Aug 11:32 pc-dir JobId 0: Fatal error: sql_create.c:84 Create DB Job record
INSERT INTO Job
(Job,Name,Ty
30 matches
Mail list logo