X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;ds=sidebyside;f=doc%2FMAINTENANCE.postgresql;h=434a87fd9abcfd485afc3063c6ed9aa9fac1e8c5;hb=d61dee18fb7b8b6a1caecb50389698aee2a28422;hp=0cc7df07b717aaf305a591e7336e5bca97e0709f;hpb=32a9f823dc39ea68d09005071f43e570a1ca81b7;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. +