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 07/08/18 16:15, Alan Brown wrote:
use the corresponding /dev/sg
Awesome, ta Alan!
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_
On 07/08/18 15:37, Adam Weremczuk wrote:
My last concern is the level of additional wear of drive and tapes.
Execution of sg_raw required the tape to be unmounted:
/dev/nst0: Device or resource busy
use the corresponding /dev/sg
Which now needs to be re-mounted for the next backup run.
My last concern is the level of additional wear of drive and tapes.
Execution of sg_raw required the tape to be unmounted:
/dev/nst0: Device or resource busy
Which now needs to be re-mounted for the next backup run.
--
> 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'
On 07/08/18 13:24, Alan Brown wrote:
sg_raw -o - -r 1024 -t 60 -v /dev/nst0 (or its /dev/sg) 8c 00 00 00 00
00 00 00 00 00 00 00 04 00 00 00
And pipe it through the script I posted at
https://github.com/hreinecke/sg3_utils/issues/18
Bingo!
id=0x writable=RO format=0 attrlen=0x0008=8
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 07/08/18 13:04, Adam Weremczuk wrote:
On 07/08/18 12:31, Alan Brown wrote:
For LTO, there are a number of relatively easy ways of answering
these questions _without_ moving the tape - as long as you have the
latest version of sg3_utils installed
Thank you Alan.
The utilities look very p
On 07/08/18 12:31, Alan Brown wrote:
For LTO, there are a number of relatively easy ways of answering these
questions _without_ moving the tape - as long as you have the latest
version of sg3_utils installed
Thank you Alan.
The utilities look very promising.
The problem is my Bacula system
I'll add that for the most part the tapealert or sg_read_attr codes you
want to use for tape aging are:
0x19 = "Nearing media life"
0x07 = "Media life"
The ones for drive trouble are:
1 Read warning
2 Write warning
3 Hard error
4 Media
5 Read failure
6 Write failure
The above are temporary
On 07/08/18 10:27, Kern Sibbald wrote:
You definitely do not want to try to run any job that examines the
tape. First, I don't know if what you are asking is possible --
possibly on the more modern drives (LTO-6 or greater), but in any
case, any time you move the tape, you wear it, so don't ma
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
You definitely do not want to try to run any job that examines the
tape. First, I don't know if what you are asking is possible --
possibly on the more modern drives (LTO-6 or greater), but in any case,
any time you move the tape, you wear it, so don't make the tape drive
move any more than ne
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 06/08/18 14:54, Adam Weremczuk wrote:
It would still be useful to have e.g. a daily cron job examining the
tape and determining how much raw uncompressed space it has left.
https://wiki.bacula.org/doku.php?id=faq#can_bacula_tell_me_how_much_space_is_left_on_my_tapes
"it's possible to kn
21 matches
Mail list logo
