Hi Bruno,
Some questions about your migration from mysql to postgres.
> We have done this with the help of this simple and stupid script
> Be sure to have the exact same level of database ( we have upgraded a 2x
> version to a 3x version)
> so we put a new temp mysql bacula db, upgrade it to the level 10 and make the
> dump from there.
The script noted below is used on a level 10 bacula database?
I thought that bacula 3x was a level 11 database?
Should this script work on a level 11 database?
After the migration to postgres did you also resequence the tables as noted in
the manual of bacula:
http://www.bacula.org/manuals/en/catalog/catalog/Installi_Configur_PostgreS.html#SECTION00450000000000000000
Thanks and regards
Jan Jaap
>
> Hope this help you a bit, (it's certainly too late 4 days later)
>
> #!/bin/sh
>
> TABLES="BaseFiles CDImages Client Counters Device File FileSet Filename Job
> JobHisto JobMedia Location LocationLog Log Media
> MediaType Path Pool Status Storage UnsavedFiles Version"
>
> for TBL in $TABLES
> do
> echo "Saving Mysql $TBL";
> mysqldump -t -c \
> --compatible=postgresql \
> --skip-quote-names \
> --skip-opt --disable-keys --lock-tables \
> bacula $TBL > $TBL.sql
> # comment below lines if you get some errors
> # We don't do this as we must change some wrong record
> # like a date end having a 0000-00-00 value
> #
> echo "Import postgresql $TBL"
> psql -d bacula -U bacula < $TBL.sql
> echo '--end--'
> echo ""
> done
> echo '-- Finish ! --'
>
>
>
> --
>
> Bruno Friedmann
_________________________________________________________________
Een netbook met Windows 7? Hier vind je alles dat je moet weten.
www.windows.nl/netbook------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
