Tweaks from Dan

[bacula/docs] / docs / manuals / en / main / catmaintenance.tex

diff --git a/docs/manuals/en/main/catmaintenance.tex b/docs/manuals/en/main/catmaintenance.tex
index da243b0c7b33713eeb904b09ea92093f1d3608b7..3efa6d578bb19eee4151a1171304cdbfc8ba97a4 100644 (file)
--- a/docs/manuals/en/main/catmaintenance.tex
+++ b/docs/manuals/en/main/catmaintenance.tex
@@ -393,10 +393,12 @@ are created, you can create the two additional indexes using:
 \begin{verbatim}
 psql bacula
 CREATE INDEX file_jobid_idx on file (jobid);
-CREATE INDEX file_fp_idx on file (jobid, pathid, filenameid);
+CREATE INDEX file_jpf_idx on file (jobid, pathid, filenameid);
 \end{verbatim}
 \normalsize
 
+Make sure that you doesn't have an index on File (filenameid, pathid).
+
 \subsection{MySQL Indexes}
 On MySQL, you can check if you have the proper indexes by:
 
@@ -441,7 +443,7 @@ index with:
 \begin{verbatim}
 mysql bacula
 DROP INDEX Path on Path;
-CREATE INDEX Path on Path (Path(255);
+CREATE INDEX Path on Path (Path(255));
 
 DROP INDEX Name on Filename;
 CREATE INDEX Name on Filename (Name(255));