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?

--

Alexandre Chapellon

Ingénierie des systèmes open sources et réseaux.
Follow me on twitter: @alxgomz