X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;ds=sidebyside;f=doc%2FMAINTENANCE;h=df5cae54b42d7825660f804f71a9086aa6c11b2d;hb=ad39c6eee58bb0ca40cbdabe191e02ec71d248bf;hp=28d5844f6af37963a2b5c9a046b3d980f9aeeff9;hpb=2759810638b5bdc0a8d35f6d5396fa3ede1e27df;p=mir.git

diff --git a/doc/MAINTENANCE b/doc/MAINTENANCE
index 28d5844f..df5cae54 100755
--- a/doc/MAINTENANCE
+++ b/doc/MAINTENANCE
@@ -1,5 +1,39 @@
 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
 
-This genrates a tar file including blobs as data.
\ No newline at end of file
+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
+
+We also have misc. perl scripts to merge Large Objects from other DB's.
+these can be used as a basis to write your own custom scripts.
+
+USER MANAGMENT IN POSTGRESQL
+
+-- set owner of datbase
+select * from pg_database;
+select * from pg_user;
+update pg_database set datdba=ID_FROM_PG_USER where datname=DATABASENAME
+
+-- find all tables to grant privs / select is just building sql
+-- to be exectued
+
+select 'grant all on '||relname||' to "de_indy";'
+from pg_class
+where relname not like 'pg%'
+order by relname;
+
+-- alter table owner / select is just building sql
+-- to be exectued
+select 'alter table '||relname||' owner to "de_indy";'
+from pg_class
+where relname not like 'pg%'
+order by relname;
\ No newline at end of file