Thank you Bill.  After adjusting for postgresql, that worked like a charm.

Patti 


On 5/1/15, 6:04 PM, "Bill Arlofski" <waa-bacula AT revpol DOT com> 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
>Bacula-users AT lists.sourceforge DOT net
>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
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users