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

Dear Marco van Wieringen,

In message <loom.20121228T234109-522 AT post.gmane DOT org> you wrote:
> 
> > I have no idea what to try next.  Any pointers?  All help welcome.
> Maybe try the in 2010 working solution available here
> 
> http://mtu.net/~jpschewe/blog/2010/06/migrating-bacula-from-mysql-to-postgresql/
> 
> which is way more up to date then anything in the current docs which talk
> about a 1.x version of 8+ years ago.

Indeed - the document says:

         This process was tested using the following software
         versions:

             Linux Mandrake 10/Kernel 2.4.22-10 SMP
             Mysql Ver 12.21 Distrib 4.0.15, for mandrake-linux-gnu (i586)
             PostgreSQL 7.3.4
             Bacula 1.34.5

No surprise this is breaking down.


With your description I get no errors, but I'm still not through.
Observations:

- With the options used here, mysqldump needs much longer, and it
  consumes an awful lot of memory - in my case close to 14 GB.  I had
  to add extra swp space because the 4 GB RAM / 4 GB swap I had on my
  ol d DB server did not work.

- The generates SQL dump is about twice as large as the dumps I got
  before.

- The import into PostgreSQL is terribly slow.  It spits out a large
  number of lines "INSERT 0 1" on the terminal (7.7 millions such
  lines so far, after about 20 hours of run time); but my SQL dump
  file contains more than 72 millions 'INSERT INTO' lines.  Extra-
  polating from that the import will take at least 190 hours or about 
  8 days.  And this is only the smaller of my bacula databases...

  Is there something going wrong?  I guess there is no way to check
  before the process completes, right?

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
"What if" is a trademark of Hewlett Packard, so stop using it in your
sentences without permission, or risk being sued.

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