postgresql vacuum / vacuum analyze

[mir.git] / doc / MAINTENANCE

diff --git a/doc/MAINTENANCE b/doc/MAINTENANCE
index 28d5844..b0e2334 100755 (executable)
--- a/doc/MAINTENANCE
+++ b/doc/MAINTENANCE
@@ -1,5 +1,15 @@
 To dump mir database <dbname>:
+       pg_dumplo -a -d <dbname> -s /dumpdir/dir
+       pg_dump -c -D -f /dumpdir/<dbname>.sql <dbname>
+this generates a dir with all blobs and a sql-file with all data.
 
-       pg_dump -b -o -F t <dbname> > mir_dump.tar
+To restore the database:
+       psql <dbname> < <dbname>.sql
+       pgdump_lo -i -d <dbname> -s /dumpdir/dir
+
+Every once in a while (or make a script) postgresql database should
+be "cleaned". See postgresql docs for commands VACUUM and VACUUM ANALYZE
+
+Every once in a while (or make a script) postgresql database should
+be "cleaned". See postgresql docs for commands VACUUM and VACUUM ANALYZE
 
-This genrates a tar file including blobs as data.
\ No newline at end of file