Bacula-users

Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-22 04:57:15
Subject: Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long
From: Marcus Mülbüsch <muelbuesch AT as-infodienste DOT de>
To: bacula-users AT lists.sourceforge DOT net
Date: Wed, 22 Jun 2011 10:54:31 +0200
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

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