On Dec 30, 2012, at 4:50 AM, Wolfgang Denk <wd AT denx DOT de> wrote:

> 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_.

I see things in there which I feel are suspect. Eg the dates; they should be 
null. 

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

I would look at non-Bacula resources. What you are doing is 
Postgresql-specific.  

-- 
Dan Langille
http://langille.org/
------------------------------------------------------------------------------
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