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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
