Zitat von [email protected]:
Zitat von Kai Zimmer <[email protected]>:Hi,i'm new to bareos and really happy with it - except that i used mysql as a database and it's taking ages to make new full backups. The ibdata1 file has currently 112 GB. I hope that a switch to postgres would increase the backup speed. Is there a way to convert bareos mysql data to postgres?best, KaiHello, there are ways to migrate data from MySQL to PostgreSQL like listed here: https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL http://mtu.net/~jpschewe/blog/2010/06/migrating-bacula-from-mysql-to-postgresql/But the question is if it isn't better to use the MySQL as a "read-only" fallback and start with PostgreSQL from scratch. This would also clean up cruft which you otherwise need to purge with bareos-dbcheck after some time. As it is a backup system and not a archiv i would simply use a new storage/tape-pool and free the old one as it is expired. With tape you might also use something like bscan to recreate the database content, but it is slow as hell.Regards Andreas
Of course you should also use this tuning advice: https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server 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.
smime.p7s
Description: S/MIME Cryptographic Signature
