Thank you Bill. After adjusting for postgresql, that worked like a charm. Patti
On 5/1/15, 6:04 PM, "Bill Arlofski" <[email protected]> wrote: >On 05/01/2015 05:14 PM, Clark, Patricia A. wrote: >> I am in the process of migrating from one bacula system to another. In >>order to have multiple storage daemons and autochangers, I am changing >>my media type from LTO-5 to LTO-5-admin and the pool is changing from >>MYPOOL to POOL5a. We imported and updated the catalog. I can modify >>the volumes and give the new pool as POOL5a, but I still need to change >>the media type without relabeling the volumes. I've searched the >>documentation and the list without finding a viable answer. Is there a >>command that I can use or is using SQL a workable option? >> > >Hi Patricia > >You can use two simple SQL commands: > ># mysql -u bacula -pPassword bacula > >First, get the pool Id's: > >> SELECT PoolId, Name FROM Pool; > >Then update your moved media: >> UPDATE Media SET MediaType='LTO-5-admin' WHERE >>PoolId='actualPOOL5a-PoolId'; > > >Hope this helps on a late Friday afternoon. ;) > >Bill > > >-- >Bill Arlofski >Reverse Polarity, LLC >http://www.revpol.com/ >-- Not responsible for anything below this line -- > >-------------------------------------------------------------------------- >---- >One dashboard for servers and applications across Physical-Virtual-Cloud >Widest out-of-the-box monitoring support with 50+ applications >Performance metrics, stats and reports that give you Actionable Insights >Deep dive visibility with transaction tracing using APM Insight. >http://ad.doubleclick.net/ddm/clk/290420510;117567292;y >_______________________________________________ >Bacula-users mailing list >[email protected] >https://lists.sourceforge.net/lists/listinfo/bacula-users > ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
