Hello, Am 23.11.2018 23:16 schrieb Alejandro Hamann <[email protected]>:
Hello. I wanted to know if it is possible to merge several catalogs into one; my goal is to convert the current configuration based on multiple catalogs, to a new more standard configuration, of a single catalog. At the beginning, I thought that because of the number of files and the high retention times of files from a couple of pools (in some cases about 50 years), the catalogs were going to be very big. After a while, I see that the catalogs remain "small" (two catalogs of 1.4 GB, another of 150 MB and a fourth catalog of 30 MB); and then, I thought: "having multiple catalogs is a real pain, I should have only one, since there are more pains than benefits." So, how could I "collect" my four catalogs into one? (if that were possible). I have no problem adapting the Bareos configuration. My problem is with the part of the database (I use PostgreSQL). I imagine that maybe I could adapt the configuration so that it handles a single catalog, and that this catalog is one of the ones I already have now. And then, somehow, import the tapes that belonged to other catalogs in the new "default catalog" (but with the possibility of maintaining the list of files, in order to recover some files individually later). But I do not know how to do this last part. Any soul that helps me a little? Regards! -- Pablo A. Hamann -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout. for doing this, you'd have to join the databases. I guess you have one database per catalog. Within that database there is the definition of what pools exist, which media is in which pool, which job is spread on which medias, which files belong to which jobs and so on. To join this information, you should pick the biggest catalog you have regarding pools and jobs and take this as the remaining one. Then you have to move the information from a smaller catalog to the bigger one creating new pool entries to the bigger ones respresenting the ones of your smaller catalog. You continue doing this for all the items you want to move, but you have to look for referential integrity. There are id fields in nearly every table representing the relation between the items. I guess, it is possible to do, but it is really MUCH work and error prone. So if you decide to do, better make a backup of all your catalogs and stop the bareos daemons while editiing the database entries. Regards, Andreas -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
