Hello Ana and Kern
I know that migration Jobs can be used to move volumes to another Storage,
but I guess is a lost of time using it if I will just replace the old disk
for a new one with more capacity.
In my previous example I said I have 2 storages/disks, so I have volumes
in both disks and I want to move all of them to just one bigger hard disk.
For this I suggested to create a command in bconsole to update volumes
Storage.
I don't know how the command below works if I change volumes Pool to
Another Pool that is in another storage
*update
11: Pool
2: Daily
Enter a Volume name or *MediaId: Daily-Volume-001
Updating Volume "Daily-Volume-001"
Current Pool is: Daily
Enter new Pool name: Monthly
Best Regards
*Wanderlei Hüttel*
http://www.huttel.com.br
2016-05-06 4:26 GMT-03:00 Kern Sibbald <k...@sibbald.com>:
> Hello Wanderei,
>
> Well, you simply: "mv /old/path/<volumes> /new/path".
> which will essentially do a cp followed by an rm if the old and new paths
> are on different devices, otherwise it is a sort of directory entry change.
>
> If you start changing your bacula-dir.conf storage definition or those in
> the bacula-sd.conf file, then you might in some cases run into problems.
>
> Note:
> By changes by hand, I mean any kind of modification of the database.
> Bacula ensures that the database is locked during database modifications,
> but when you do it by hand, you can, and users have had, conflicts with
> what Bacula was doing to the database (e.g. purging a volume while Bacula
> is writing it), which has for some people resulted in failed restores.
> Note, even using bconsole, it is possible to interfere with proper backups.
>
> On the other hand "reading" the database to produce reports, ... is
> something that I encourage.
>
> Best regards,
> Kern
>
>
> On 05/05/2016 01:24 PM, Wanderlei Huttel wrote:
>
> Hello Kern
>
> I understand your concerns about make changes by hand in bacula database,
> but it wouldn't be interesting create an option in update to move volumes
> to another Storage?
> An exemple: you can have 2 disks with 1TB (everyone with one storage) and
> you will change for a new one of 4TB. In this case is not necessary 2
> storages but just one.
> You can move all volumes from both 1TB hard disk to the new one 4TB.
>
>
> Best Regards
>
> *Wanderlei Hüttel*
> <http://www.huttel.com.br>http://www.huttel.com.br
>
> 2016-05-04 8:18 GMT-03:00 Kern Sibbald <k...@sibbald.com>:
>
>> Hello,
>>
>> I strongly encourage users to use Bacula bconsole commands to accomplish
>> *all* modifications of the catalog database. Making changes by hand using
>> SQL will quite often lead to inconsistencies in the catalog that can come
>> back to haunt you. In addition, much of the SQL for MySQL and PostgreSQL is
>> different, which can also cause problems. Bacula via bconsole knows how to
>> handle the database for both MySQL and Postges. It is *extremely* rare
>> that I do any modification of the database by hand -- maybe 2 times in 16
>> years.
>>
>> Best regards,
>> Kern
>>
>>
>> On 05/04/2016 12:13 PM, Florian Splett wrote:
>>
>> Hello and sorry for the late response.
>>
>> I just wanted to thank you for all the information.
>> Definitely helped me decide on how to approach the issue.
>>
>> Regards,
>>
>> Florian S.
>> Am 28.04.2016 um 13:04 schrieb Wanderlei Huttel:
>>
>> Hello Florian
>>
>>
>> 2016-04-28 5:47 GMT-03:00 Florian Splett < <florian.spl...@web.de>
>> florian.spl...@web.de>:
>>
>>> Hello, bacula community.
>>>
>>> The harddrive my bacula system is using to store its volumes is reaching
>>> its maximum capacity, so I had the following plan for my network:
>>>
>>> I want to manually move the old volumes onto an external harddrive and
>>> keep that somewhere else.
>>>
>>> Now what i want to ask is: Does this cause complications with the
>>> catalog?
>>>
>> It depends if they will be recycle soon or not
>>
>>> I guess so, since the volumes will be just gone.
>>> Can I somehow tell the catalog that the volumes should be marked as
>>> "unavailable" or something like that?
>>>
>> You can update Volume Status and set to "Archive" or "Disabled"
>> *update
>> 1: Volume parameters
>> 1: Volume Status
>>
>>
>>> ...or is it in fact perfectly fine to just remove those volumes?
>>>
>> Or you could create another Storage Resource in bacula-dir.conf and new
>> Device in bacula-sd.conf and use this external harddrive as a Storage.
>> Move those Volumes to the external harddrive.
>>
>> Get StorageId from New Storage:
>> *sqlquery
>> Entering SQL query mode.
>> Terminate each query with a semicolon.
>> Terminate query mode with a blank line.
>> Enter SQL query: select StorageID, Name, Autochanger from Storage;
>> +-----------+---------------+-------------+
>> | StorageID | Name | Autochanger |
>> +-----------+---------------+-------------+
>> | 1 | StorageLocal1 | 0 |
>> | 3 | StorageLocal2 | 0 |
>> +-----------+---------------+-------------+
>>
>> Use this below sql to get information about Volumes x Pool x Storage
>>
>> select M.MediaId, M.VolumeName, M.StorageId, S.Name, M.PoolId, P.Name from
>> Media M left join Storage S on (M.StorageId = S.StorageId) left join
>> Pool P on (M.PoolId = P.PoolId) order by M.VolumeName;
>>
>> *sqlquery
>> Entering SQL query mode.
>> Terminate each query with a semicolon.
>> Terminate query mode with a blank line.
>> Enter SQL query: select M.MediaId, M.VolumeName, M.StorageId, S.Name,
>> M.PoolId, P.Name from Media M left join Storage S on (M.StorageId =
>> S.StorageId) left join Pool P on (M.PoolId = P.PoolId) orde; by M.VolumeNam
>>
>> +---------+---------------------+-----------+---------------+--------+---------+
>> | MediaId | VolumeName | StorageId | Name | PoolId |
>> Name |
>>
>> +---------+---------------------+-----------+---------------+--------+---------+
>> | 36 | Volume-Diario-0001 | 1 | StorageLocal1 | 6 |
>> Diaria |
>> | 51 | Volume-Diario-0002 | 1 | StorageLocal1 | 6 |
>> Diaria |
>> | 74 | Volume-Diario-0003 | 1 | StorageLocal1 | 6 |
>> Diaria |
>> | 89 | Volume-Diario-0004 | 1 | StorageLocal1 | 6 |
>> Diaria |
>> | 96 | Volume-Diario-0005 | 1 | StorageLocal1 | 6 |
>> Diaria |
>> | 97 | Volume-Diario-0006 | 1 | StorageLocal1 | 6 |
>> Diaria |
>> | 98 | Volume-Diario-0007 | 1 | StorageLocal1 | 6 |
>> Diaria |
>> ...
>>
>> Update the volumes that you have moved to external hard drive to
>> NewStorage (change StorageId).
>>
>> *sqlquery
>> update Media set StorageId = 3 where PoolId = 6; # Move all volumes from
>> a Pool or
>> *sqlquery
>> update Media set StorageId = 3 where MediaId in (36,51,74,89,96);
>>
>> I guess this can help you.
>>
>> Best Regards
>>
>> *Wanderlei Hüttel*
>> <http://www.huttel.com.br>http://www.huttel.com.br
>>
>>
>>> Regards,
>>>
>>> Florian S.
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Find and fix application performance issues faster with Applications
>>> Manager
>>> Applications Manager provides deep performance insights into multiple
>>> tiers of
>>> your business applications. It resolves application problems quickly and
>>> reduces your MTTR. Get your free trial!
>>> https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
>>> _______________________________________________
>>> Bacula-users mailing list
>>> Bacula-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Find and fix application performance issues faster with Applications Manager
>> Applications Manager provides deep performance insights into multiple tiers
>> of
>> your business applications. It resolves application problems quickly and
>> reduces your MTTR. Get your free
>> trial!https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
>>
>>
>>
>> _______________________________________________
>> Bacula-users mailing
>> listBacula-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/bacula-users
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Find and fix application performance issues faster with Applications Manager
>> Applications Manager provides deep performance insights into multiple tiers
>> of
>> your business applications. It resolves application problems quickly and
>> reduces your MTTR. Get your free
>> trial!https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
>>
>>
>>
>> _______________________________________________
>> Bacula-users mailing
>> listBacula-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/bacula-users
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Find and fix application performance issues faster with Applications
>> Manager
>> Applications Manager provides deep performance insights into multiple
>> tiers of
>> your business applications. It resolves application problems quickly and
>> reduces your MTTR. Get your free trial!
>> https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
>> _______________________________________________
>> Bacula-users mailing list
>> Bacula-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>
>>
>
>
> ------------------------------------------------------------------------------
> Find and fix application performance issues faster with Applications Manager
> Applications Manager provides deep performance insights into multiple tiers of
> your business applications. It resolves application problems quickly and
> reduces your MTTR. Get your free
> trial!https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
>
>
>
> _______________________________________________
> Bacula-users mailing
> listBacula-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/bacula-users
>
>
>
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
