On 08/06/15 21:17, Dimitri Maziuk wrote:
> 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

This won't work.

You need to set portability mode in the dump it will need extensive 
rework before pgsql will accept it.

See http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL





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