From: Ant Zucaro <azucaro@gmail.com>
Date: Sat, 26 Aug 2017 15:03:11 +0000 (-0400)
Subject: Make mention of needing superuser for drop & load, note cron scripts and SQLs.
X-Git-Url: http://de.git.xonotic.org/?p=xonotic%2Fxonstatdb.git;a=commitdiff_plain;h=b136afba6b66545792d08e1ce3a861df651fc085

Make mention of needing superuser for drop & load, note cron scripts and SQLs.
---

diff --git a/README.md b/README.md
index d86430c..c18762f 100644
--- a/README.md
+++ b/README.md
@@ -26,6 +26,13 @@ Next, create the database itself:
         OWNER=xonstat
         CONNECTION LIMIT=-1;
 
+If you intend to use the `drop_and_load.shl` script in the scripts folder, you may want to give
+the application user superuser within the database. To do that you can use the following command:
+
+    postgres=# alter user xonstat with superuser;
+
+When done, exit the psql prompt: 
+
     postgres=# \q
 
 Next, as your regular system user, log into the newly created database
@@ -60,7 +67,8 @@ And that's it!
 
 Do note that there are a few maintenance scripts that can be used
 once the database begins accumulating data. These can be found in 
-the scripts subdirectory. A summary of what they do follows:
+the scripts subdirectory and are intended to be implemented as cron jobs. 
+A summary of what they do follows:
 
   update\_elos.sql - will decrease player elo records by one point 
                     day for every day after 30 days of inactivity
@@ -71,6 +79,10 @@ the scripts subdirectory. A summary of what they do follows:
   update\_ranks.sql - will populate the player\_ranks table each day
                      according to the elo values when it is run.
 
+  refresh\_$TABLE\_mv.sql - updates the "materialized view" named by $TABLE.
+
+  purge\_anticheat\_log.sql - deletes old anticheat data.
+
 There is also a "merge players" function in the functions sub-
 directory. This can be used to merge two players together into one
 record in the presentation layer of XonStat. It can be run as follows: