>>>>> On Tue, 27 Mar 2007 11:24:23 +0000, Jaime Ventura said:
>
> Sorry for my previous errorious explanation and thanks for you reply.
Don't forget the various catalog maintenance scripts too.
__Martin
>
> Kern Sibbald wrote:
> > On Tuesday 27 March 2007 11:40, Jaime Ventura wrote:
> >
> >> Thanks Kern for your reply.
> >> According to your instructions, seems like you are explaining how to
> >> change the database name, right?
> >>
> >
> > Yes
> >
> >
> >> Where I say to the "catalog's name", Im referring to the catalog
> >> resource name and not the database name itself.
> >>
> >
> > OK, I speak of that as the name of the Catalog resource.
> >
> > You simply change the name everywhere it appears, then restart the
> > Director,
> > or optionally use the "reload" command.
> >
> >
> >
> >
> >> I mean, for example, change from:
> >>
> >> Catalog {
> >> Name = MyCatalog
> >> dbname = bacula; user = bacula; password = "XXXXX"
> >> }
> >> to:
> >> Catalog {
> >> Name = CatalogForSERVERS
> >> dbname = bacula; user = bacula; password = "XXXXX"
> >> }
> >>
> >> Thanks, once again,
> >> Jaime
> >>
> >> Kern Sibbald wrote:
> >>
> >>> On Monday 26 March 2007 20:49, Jaime Ventura wrote:
> >>>
> >>>
> >>>> Hello,
> >>>> Is there a safe way to change a catalog's name?
> >>>> Can I simply change it on the config files or its also mentioned on
> >>>> the database itself?
> >>>>
> >>>>
> >>> First backup the database before doing anything.
> >>>
> >>> I cannot reply for PostgreSQL, but for SQLite, you simply change the name
> >>>
> > of
> >
> >>> the database file. For MySQL, you change the name of the directory that
> >>> holds the database files, and you must also grant access to the users
> >>> that
> >>> will access the new name.
> >>>
> >>> For both, you must also change the name in the bacula-dir.conf Catalog
> >>> resource entry.
> >>>
> >>> For PostgreSQL, you will need to find a PostgreSQL expert, or simply
> >>>
> > export
> >
> >>> the database such as Bacula does when it backs it up, create a new one by
> >>> modifying the appropriate scripts and running them, then feeding the
> >>>
> > export
> >
> >>> file back into PostgreSQL, and then making sure users have access rights
> >>>
> > to
> >
> >>> the new name. This would also work with MySQL and SQLite and is a more
> >>> conservative (but slower) way of doing the change.
> >>>
> >>>
> >>>
> >>>> Thanks
> >>>> --
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> Jaime Ventura
> >>>> [Infra-estruturas e Comunicações]
> >>>>
> >>>> Rua Dr. António Bernardino de Almeida, 431
> >>>> 4200 - 072 Porto
> >>>> Telef: +351 22 834 05 00 (04) - ext. 1641
> >>>> Fax: +351 22 832 11 59
> >>>>
> >>>> e-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> >>>> url: www.isep.ipp.pt <http://www.isep.ipp.pt>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> -------------------------------------------------------------------------
> >>>> Take Surveys. Earn Cash. Influence the Future of IT
> >>>> Join SourceForge.net's Techsay panel and you'll get the chance to share
> >>>>
> > your
> >
> >>>> opinions on IT & business topics through brief surveys-and earn cash
> >>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> >>>> _______________________________________________
> >>>> Bacula-users mailing list
> >>>> [email protected]
> >>>> https://lists.sourceforge.net/lists/listinfo/bacula-users
> >>>>
> >>>>
> >>>>
> >>> -------------------------------------------------------------------------
> >>> Take Surveys. Earn Cash. Influence the Future of IT
> >>> Join SourceForge.net's Techsay panel and you'll get the chance to share
> >>>
> > your
> >
> >>> opinions on IT & business topics through brief surveys-and earn cash
> >>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> >>> _______________________________________________
> >>> Bacula-users mailing list
> >>> [email protected]
> >>> https://lists.sourceforge.net/lists/listinfo/bacula-users
> >>>
> >>>
> >>>
> >> --
> >>
> >>
> >>
> >>
> >>
> >>
> >> Jaime Ventura
> >> [Infra-estruturas e Comunicações]
> >>
> >> Rua Dr. António Bernardino de Almeida, 431
> >> 4200 - 072 Porto
> >> Telef: +351 22 834 05 00 (04) - ext. 1641
> >> Fax: +351 22 832 11 59
> >>
> >> e-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> >> url: www.isep.ipp.pt <http://www.isep.ipp.pt>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>
> --
>
>
>
>
>
>
> Jaime Ventura
> [Infra-estruturas e Comunicações]
>
> Rua Dr. António Bernardino de Almeida, 431
> 4200 - 072 Porto
> Telef: +351 22 834 05 00 (04) - ext. 1641
> Fax: +351 22 832 11 59
>
> e-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> url: www.isep.ipp.pt <http://www.isep.ipp.pt>
>
>
>
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Bacula-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users