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 > >> Bacula-users@lists.sourceforge.net > >> 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 > > Bacula-users@lists.sourceforge.net > > 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> > > > > > ------------------------------------------------------------------------- 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 Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users