X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=doc%2FMAINTENANCE.postgresql;fp=doc%2FMAINTENANCE.postgresql;h=434a87fd9abcfd485afc3063c6ed9aa9fac1e8c5;hb=7c327459c60304425af9d63fc55b0451825b9ffb;hp=0cc7df07b717aaf305a591e7336e5bca97e0709f;hpb=451930fb30949a7e1838f23ce9d1076adaa71c54;p=mir.git diff --git a/doc/MAINTENANCE.postgresql b/doc/MAINTENANCE.postgresql index 0cc7df07..434a87fd 100755 --- a/doc/MAINTENANCE.postgresql +++ b/doc/MAINTENANCE.postgresql @@ -23,22 +23,6 @@ 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 +If you want to change the db user of a mir db, there's a script for +that in mir/dbscripts/extra. +