On Wed, 22 Jun 2011 10:54:31 +0200, Marcus Mülbüsch
<muelbuesch AT as-infodienste DOT de> wrote:
> Am 22.06.2011 06:14, schrieb Stuart McGraw:
> 
>> You can identify the indexes from the CREATE INDEX commands
>> in /usr/libexec/bacula/make_postgresql_tables.  Drop them
>> prior to loading, and then rerun the CREATE INDEX commands
>> after loading -- it can make a big difference in loading
>> time.
> 
> I will watch whether psql will be finished today, and if it's not: 
> switch back to mysql for this weekend (which thanks to a holiday and a 
> bridging day will start this evening ;)
> 
>     Next week I'll try your suggestion.
> 
>     Thanks for the instructions.
> 
> Marcus

Hello, 

I don't know how you dumped your mysql database.
Did you try to use mysqldump -T ? mysql2pgsql ?
I used some other scripts to migrate data pieces. I will look for them
this evening...

HTH.
Jérôme Blion.

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