{"id":1530,"date":"2020-01-27T22:02:29","date_gmt":"2020-01-27T19:02:29","guid":{"rendered":"https:\/\/artem.services\/?p=1530"},"modified":"2020-02-03T17:08:24","modified_gmt":"2020-02-03T14:08:24","slug":"postgres-%d0%b7%d0%b0%d0%bf%d1%80%d0%b5%d1%82-%d0%b7%d0%b0%d0%bf%d0%b8%d1%81%d0%b8-%d0%b2-%d0%b1%d0%b0%d0%b7%d1%83-%d0%b4%d0%b0%d0%bd%d0%bd%d1%8b%d1%85","status":"publish","type":"post","link":"https:\/\/artem.services\/?p=1530","title":{"rendered":"Postgres &#8212; \u0417\u0430\u043f\u0440\u0435\u0442 \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445"},"content":{"rendered":"<p>\u0427\u0442\u043e\u0431\u044b \u043f\u0435\u0440\u0435\u0432\u0435\u0441\u0442\u0438 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 <strong>read-only<\/strong>, \u043d\u0443\u0436\u043d\u043e \u0437\u0430\u0434\u0430\u0442\u044c \u0444\u043b\u0430\u0433 &quot;<strong>default_transaction_read_only<\/strong>&quot; \u0432 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 &quot;<strong>true<\/strong>&quot;<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nALTER DATABASE dababase_name SET default_transaction_read_only = true;\r\n<\/pre>\n<p>&nbsp;<\/p>\n<blockquote><p>\u0413\u0434\u0435 &quot;<strong>dababase_name<\/strong>&quot; &#8212; \u0438\u043c\u044f \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445<\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p>\u0412\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u043c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0411\u0414:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nALTER DATABASE dababase_name SET default_transaction_read_only = false;\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>\u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0442\u0435\u043a\u0443\u0449\u0435\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0444\u043b\u0430\u0433\u0430 \u043c\u043e\u0436\u043d\u043e \u0442\u0430\u043a:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nSELECT name, setting FROM pg_settings WHERE name = 'default_transaction_read_only';\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u0427\u0442\u043e\u0431\u044b \u043f\u0435\u0440\u0435\u0432\u0435\u0441\u0442\u0438 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 read-only, \u043d\u0443\u0436\u043d\u043e \u0437\u0430\u0434\u0430\u0442\u044c \u0444\u043b\u0430\u0433 &quot;default_transaction_read_only&quot; \u0432 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 &quot;true&quot; &nbsp; \u0413\u0434\u0435 &quot;dababase_name&quot; &#8212; \u0438\u043c\u044f \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 &nbsp; \u0412\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u043c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0411\u0414: &nbsp; \u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0442\u0435\u043a\u0443\u0449\u0435\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0444\u043b\u0430\u0433\u0430 \u043c\u043e\u0436\u043d\u043e \u0442\u0430\u043a:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[45],"tags":[1201,46,47,48,1199],"_links":{"self":[{"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts\/1530"}],"collection":[{"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1530"}],"version-history":[{"count":4,"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts\/1530\/revisions"}],"predecessor-version":[{"id":1546,"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts\/1530\/revisions\/1546"}],"wp:attachment":[{"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1530"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1530"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}