On Friday 16 September 2005 16:57, Alan Brown wrote:
> On Fri, 16 Sep 2005, Kern Sibbald wrote:
> >> But not on upgrades from previous versions, right?
> >
> > On most upgrades, the index should not be lost, because generally an
> > upgrade adds new columns or new tables.
>
> But does an uipgrade form previous version of bacula database format add
> new indexing too?
Normally it does not add new indexing, but one time, I dropped an index, which
was a bad idea, so I added it back in a later version, not thinking that it
could duplicate an existing index.
>
> As it is, I've just dumped the keys and found substantial duplication of
> indexes ( 8 Job_Id indexes, etc) so am stripping it back a bit.
Gee, it looks like I really need to document checking/adding/deleting indexes
to the manual so that users can easily check and correct any problems. This
would probably be a nice mini-project for a script jockey.
--
Best regards,
Kern
(">
/\
V_V
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server.
Download it for free - -and be entered to win a 42" plasma tv or your very
own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
