ebl document dbcheck.sql

[bacula/docs] / docs / manuals / en / utility / progs.tex

diff --git a/docs/manuals/en/utility/progs.tex b/docs/manuals/en/utility/progs.tex
index f45f4fa88ac016fb59d78916405a4088a1152508..5213fc3dd47a85130b3ea4ccfd4f0bc14a9ca70c 100644 (file)
--- a/docs/manuals/en/utility/progs.tex
+++ b/docs/manuals/en/utility/progs.tex
@@ -1192,6 +1192,16 @@ The inconsistencies examined are the following:
 If you are using Mysql, dbcheck will ask you if you want to create temporary
 indexes to speed up orphaned Path and Filename elimination.
 
+Mostly for PostgreSQL users, we provide a pure SQL script dbcheck replacement
+in \url{examples/database/dbcheck.sql} that works with global queries instead
+of many small queries like dbcheck. Execution instructions are at the top of
+the script and you will need to type \texttt{COMMIT} at the end to validate
+modifications.
+
+If you are using bweb or brestore, don't eliminate orphaned Path, else you will
+have to rebuild \texttt{brestore\_pathvisibility} and
+\texttt{brestore\_pathhierarchy} indexes.
+
 By the way, I personally run dbcheck only where I have messed up
 my database due to a bug in developing Bacula code, so normally
 you should never need to run dbcheck in spite of the