Bacula-users

Re: [Bacula-users] Slow Attribute spooling

2015-06-08 16:20:06
Subject: Re: [Bacula-users] Slow Attribute spooling
From: Dimitri Maziuk <dmaziuk AT bmrb.wisc DOT edu>
To: bacula-users AT lists.sourceforge DOT net
Date: Mon, 08 Jun 2015 15:17:50 -0500
On 06/08/2015 02:52 PM, Denis Witt wrote:

> Database is about 2.5Gb. Is there an easy way to convert my Catalog to
> use Postgres?

If you comment out RunAfterJob in BackupCatalog job def you'll get
/var/spool/bacula/bacula.sql. That should be directly loadable into
postgres bacula db unless mysql does something silly there like using
"\N" instead of NULL:
psql -U bacula -d bacula -f /var/spool/bacula/bacula.sql

Disclaimer: I have never tried this myself.
-- 
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu

Attachment: signature.asc
Description: OpenPGP digital signature

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users