{"id":906,"date":"2023-09-04T07:27:36","date_gmt":"2023-09-04T07:27:36","guid":{"rendered":"https:\/\/www.linuxsystems.ovh\/?p=906"},"modified":"2023-09-05T10:21:23","modified_gmt":"2023-09-05T10:21:23","slug":"zmiana-live-parametrow-w-bazie","status":"publish","type":"post","link":"https:\/\/www.linuxsystems.ovh\/?p=906","title":{"rendered":"Zmiana live parametr\u00f3w w bazie postgresql"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Jak zmieni\u0107 jaki\u015b parametr live w bazie? Oczywi\u015bcie pod warunkiem, \u017ce parametr jest mo\u017cliwy do zmiany live. Na przyk\u0142adzie zmiennej: log_min_error_statement<\/p>\n\n\n\n<!--more-->\n\n\n\n<p class=\"wp-block-paragraph\">Mo\u017cna to zrobi\u0107 poprzez zalogowanie si\u0119&nbsp;do postgresa, a nast\u0119pnie:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Zobaczy\u0107 jak wygl\u0105da aktualnie zmienna:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# SHOW log_min_error_statement;\n log_min_error_statement \n-------------------------\n error\n(1 wiersz)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Zmieni\u0107 j\u0105:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# ALTER SYSTEM SET log_min_error_statement='INFO';\nALTER SYSTEM<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">U\u017cy\u0107 nast\u0119pnie pg_reload_conf():<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# SELECT pg_reload_conf();\n pg_reload_conf \n----------------\n t\n(1 wiersz)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Sprawdzi\u0107 ponownie jak wygl\u0105da zmienna:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# SHOW log_min_error_statement;\n log_min_error_statement \n-------------------------\n info\n(1 wiersz)\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Jak zmieni\u0107 jaki\u015b parametr live w bazie? Oczywi\u015bcie pod warunkiem, \u017ce parametr jest mo\u017cliwy do zmiany live. Na przyk\u0142adzie zmiennej: log_min_error_statement<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58],"tags":[],"class_list":["post-906","post","type-post","status-publish","format-standard","hentry","category-postgresql"],"_links":{"self":[{"href":"https:\/\/www.linuxsystems.ovh\/index.php?rest_route=\/wp\/v2\/posts\/906","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.linuxsystems.ovh\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linuxsystems.ovh\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linuxsystems.ovh\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxsystems.ovh\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=906"}],"version-history":[{"count":2,"href":"https:\/\/www.linuxsystems.ovh\/index.php?rest_route=\/wp\/v2\/posts\/906\/revisions"}],"predecessor-version":[{"id":912,"href":"https:\/\/www.linuxsystems.ovh\/index.php?rest_route=\/wp\/v2\/posts\/906\/revisions\/912"}],"wp:attachment":[{"href":"https:\/\/www.linuxsystems.ovh\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxsystems.ovh\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxsystems.ovh\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}