migrating bareos mysql-db to postgres?

[Kai Zimmer]

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,
Kai

[lst_...@kwsoft.de]

Zitat von Kai Zimmer <zim...@bbaw.de>:

Hello,

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

[lst_...@kwsoft.de]

Zitat von lst_...@kwsoft.de:

Of course you should also use this tuning advice:

https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

Regards

Andreas