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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users