|
Eric As Gavin pointed out, a 150GB database is huuuuuuuuuuuge for only a dozen client. Unless you have billions of files on each client there is no reason your catalog is that large. Are you sure you correctly applied job and file retention on your catalog? Also are you sure you catalog is not full of orphaned records? Before migrating to postgres (which is a good choice for big catalogs), I would look at the catalog to see if all retention period are correctly applied. Best regards. Le 21/09/2011 16:51, Erik P. Olsen a écrit : On 21/09/11 15:56, Marcio Merlone wrote:Em 21-09-2011 10:29, Gavin McCullagh escreveu:A 150GB database. That's pretty large. How many clients have you?About a dozen clients - some inactive but still with valid backup - File Retention = 6 months, Job Retention = 1 year. Most clients have few or no changes, but my storage server has 2,825,101 files on a full backup and almost 100.000 on an incremental.Which database are you using (MySQL, Postgresql)?MySQL.If you haven't seen it already, this might be useful: http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalogYes, I was there when you mail arrived. It made think about going to Postgres. Is there any upgrade path or helper to go from mysql to postgres? I am now optimizing File table and will then run dbcheck.I forgot to mention that my problem is with building the file tree. So converting to postresql may be the best thing to do. Will the following scenario work? 1. Backup the catalogue 2. Remove mysql database 3. Build postresql database 4. Restore the catalogue Or is there more to it than this? --
|
<<attachment: a_chapellon.vcf>>
------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
