On 06/21/2011 09:59 AM, Marcus Mülbüsch wrote: > I want to migrate my bacula installation from mysql to postgresql, > following the guide in > http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_Post.html#SECTION004450000000000000000 > > After dumping and converting the database the sql-file now has 9GiB. > > I began loading the db into postgres about 18 hours before, but the > process is not yet finished. Is this normal? Or did I miss an important > step? > > And the command to load the database is indeed: > > "psql -Ubacula bacula < bacula-backup.sql" > > and not the mangled version given on the linked page? > > Marcus
Did you prepare ( I suppose ) postgresql to manage bacula database. As most of distribution around send postgresql with a very very little setup (like use 32MB ram etc) Adjusting the setup of postgresql can make a huge difference. Here a 4.5Gb sql text dump, need approximatively less than 2 hours to be inserted on blank db. -- Bruno Friedmann Ioda-Net Sàrl www.ioda-net.ch openSUSE Member & Ambassador GPG KEY : D5C9B751C4653227 irc: tigerfoot ------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
