Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long
2011-06-22 04:57:15
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
|
|
|