Bacula-users

Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2012-12-30 04:52:34
Subject: Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails
From: Wolfgang Denk <wd AT denx DOT de>
To: Dan Langille <dan AT langille DOT org>
Date: Sun, 30 Dec 2012 10:50:24 +0100
Dear Dan,

In message <59739303-6CCD-4198-9F10-135CEC184503 AT langille DOT org> you wrote:
> 
> Yes.  Let the Bacula scripts create the PostgreSQL tables, then export only
> data from MySQL.

This is what I'm trying to do.

But the instructions at
http://www.bacula.org/manuals/en/catalog/catalog/Installi_Configur_PostgreS.html
simply don't work at all (no surprise, as these appear to be more than
8 years old and refer to ancient versions.

The description recommended by Marco:
http://mtu.net/~jpschewe/blog/2010/06/migrating-bacula-from-mysql-to-postgresql/
appears to work much better (at least no errors so far), albeit
_terribly_ slow.  I did not expect import times in the order of
_weeks_.


Has anybody else successfully done an update MySQL => PostgrS!L
recently?


Best regards,

Wolfgang Denk

-- 
DENX Software Engineering GmbH,     MD: Wolfgang Denk & Detlev Zundel
HRB 165235 Munich, Office: Kirchenstr.5, D-82194 Groebenzell, Germany
Phone: (+49)-8142-66989-10 Fax: (+49)-8142-66989-80 Email: wd AT denx DOT de
: ... and it's got weird formatting - Notepad, Write, Works  3  can't
: decipher it, and it's too big to go in DOS Edit. Help!
Install an operating system. :-)                  -- Tom Christiansen

------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_123012
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users