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_catalog
> Yes, 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?

-- 
Erik

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