Hello Martin,
thanks, this type of cast has helped with the volume names in the
postgres catalog!
On Wed, Sep 07, 2022 at 04:32:58PM +0100, Martin Simmons wrote:
> This might work but I've not tested it:
>
> cast type tinyblob to text using varbinary-to-string
>
I've extended the CAST to include "blob" types as well, now it looks
like bacula finds previous jobs, volumes etc. in the converted
database using this pgloader ("import_bacula.lisp") file:
###########################################################################
LOAD DATABASE
FROM mysql://bacula:XXXXXXXX@localhost/bacula
INTO postgresql://bacula:XXXXXXXXX@localhost/bacula
CAST type tinyblob to text using varbinary-to-string,
type blob to text using varbinary-to-string,
type binary to char using varbinary-to-string
BEFORE LOAD DO
$$ set schema 'bacula' ; $$ ;
###########################################################################
and then running the following sequence of commands (I'm using local
copies of the bacula scripts in postgres' HOME for convenience):
echo "drop database bacula; drop role bacula; " | psql
~/create_postgresql_database
~/make_postgresql_tables
~/grant_postgresql_privileges
pgloader import_bacula.lisp
I think switching the schema to "bacula" (which is created by the
scripts) is also critical for bacula to be able to find its stuff in
the postgres catalog.
Some issues remain though:
o auto-purging / recycling doesn't work. I see a message about a disk
volume being purged, but the status in "media" remains "Used" until I
purge the volume in question manually.
o query.sql probably needs to be replaced with a postgres-compatible
version.
Thanks again for your help folks, it's much appreciated. I think we're
one step closer in creating a working pgloader config file to help
folks who want to migrate from mariadb to postgresql :-)
All the best,
Uwe
--
Uwe Schürkamp // email: <uwe.schuerk...@bertelsmann.de>
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
