{"id":4562,"date":"2014-11-28T13:56:19","date_gmt":"2014-11-28T11:56:19","guid":{"rendered":"http:\/\/skeletor.org.ua\/?p=4562"},"modified":"2014-11-28T13:56:19","modified_gmt":"2014-11-28T11:56:19","slug":"postgresql-%d0%bc%d0%b5%d0%bd%d1%8f%d0%b5%d0%bc-ownera-%d0%b4%d0%bb%d1%8f-%d0%b2%d1%81%d0%b5%d1%85-%d1%82%d0%b0%d0%b1%d0%bb%d0%b8%d1%86-%d0%b2-%d0%b1%d0%b0%d0%b7%d0%b5","status":"publish","type":"post","link":"https:\/\/skeletor.org.ua\/?p=4562","title":{"rendered":"[postgresql] \u041c\u0435\u043d\u044f\u0435\u043c owner&#8217;a \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 \u0432 \u0431\u0430\u0437\u0435"},"content":{"rendered":"<p>\u0421\u043e\u0431\u0441\u0442\u0432\u0435\u043d\u043d\u043e \u0441\u0430\u043c \u0441\u043a\u0440\u0438\u043f\u0442. \u0412 \u043d\u0451\u043c \u0442\u0430\u043a \u0436\u0435 \u0435\u0441\u0442\u044c \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043d\u0430 \u0437\u0430\u043f\u0443\u0441\u043a \u043e\u0442 \u043d\u0443\u0436\u043d\u043e\u0433\u043e \u044e\u0437\u0435\u0440\u0430.<\/p>\n<p><!--more--><\/p>\n<pre>#!\/bin\/sh\r\n\r\nDB_NAME=$1\r\nPSQL=\/usr\/bin\/psql\r\nEGREP=\/usr\/bin\/egrep\r\n\r\nif [ $# = 1 ]\r\nthen\r\n\r\n        if [ `id -nu` = 'postgres' ]\r\n        then\r\n\r\n                for S in `$PSQL -qAt -c \"SELECT schema_name FROM information_schema.schemata;\" $DB_NAME | $EGREP -v 'pg_|information_schema'`\r\n                do\r\n                        for tbl in `$PSQL -qAt -c \"SELECT table_name FROM information_schema.tables WHERE table_schema = '$S';\" $DB_NAME` \r\n                        do  \r\n                                $PSQL -c \"ALTER TABLE ${S}.${tbl} OWNER TO deposit\" $DB_NAME\r\n                        done\r\n                done\r\n\r\n        else\r\n                echo \"This script run ONLY from user postgres\"\r\n                echo \"Example: su - postgres -c \\\"$0\\\"\"\r\n                exit 1\r\n        fi\r\n\r\nelse\r\n        echo \"Error in usage\"\r\n        echo \"Use: $0 DB_NAME\"\r\n        exit 1\r\nfi\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u0421\u043e\u0431\u0441\u0442\u0432\u0435\u043d\u043d\u043e \u0441\u0430\u043c \u0441\u043a\u0440\u0438\u043f\u0442. \u0412 \u043d\u0451\u043c \u0442\u0430\u043a \u0436\u0435 \u0435\u0441\u0442\u044c \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043d\u0430 \u0437\u0430\u043f\u0443\u0441\u043a \u043e\u0442 \u043d\u0443\u0436\u043d\u043e\u0433\u043e \u044e\u0437\u0435\u0440\u0430.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-4562","post","type-post","status-publish","format-standard","hentry","category-databases"],"_links":{"self":[{"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=\/wp\/v2\/posts\/4562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4562"}],"version-history":[{"count":1,"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=\/wp\/v2\/posts\/4562\/revisions"}],"predecessor-version":[{"id":4563,"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=\/wp\/v2\/posts\/4562\/revisions\/4563"}],"wp:attachment":[{"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}