On Dec 30, 2012, at 4:50 AM, Wolfgang Denk <w...@denx.de> wrote: > Dear Dan, > > In message <59739303-6ccd-4198-9f10-135cec184...@langille.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
