{"id":127,"date":"2024-12-27T19:26:20","date_gmt":"2024-12-27T22:26:20","guid":{"rendered":"https:\/\/recover.rdconsolo.com.br\/?p=127"},"modified":"2024-12-27T19:33:54","modified_gmt":"2024-12-27T22:33:54","slug":"configurar-collate-e-ctype-no-postgresql","status":"publish","type":"post","link":"https:\/\/rdconsolo.com.br\/?p=127","title":{"rendered":"Configurar COLLATE e CTYPE no PostgreSQL"},"content":{"rendered":"\n<p>Ao instalar um novo servi\u00e7o de servidor PostgreSQL as op\u00e7\u00f5es de COLLATE e CTYPE podem estar fora da configura\u00e7\u00e3o ideal.<\/p>\n\n\n\n<p>N\u00e3o \u00e9 poss\u00edvel alterar essas op\u00e7\u00f5es em bancos j\u00e1 criados. Uma solu\u00e7\u00e3o \u00e9 fazer um backup, criar o banco com as op\u00e7\u00f5es desejadas e restaurar o banco na sequencia.<\/p>\n\n\n\n<p>Para deixar as op\u00e7\u00f5es no estado padr\u00e3o desejado, execute o script abaixo.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">ALTER database template1 is_template=false;\n\nDROP database template1;\n\nCREATE DATABASE template1\nWITH OWNER = postgres\n   ENCODING = 'UTF8'\n   TABLESPACE = pg_default\n   LC_COLLATE = 'en_US.UTF-8'\n   LC_CTYPE = 'en_US.UTF-8'\n   CONNECTION LIMIT = -1\n   TEMPLATE template0;\n\nALTER database template1 is_template=true;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Ao instalar um novo servi\u00e7o de servidor PostgreSQL as op\u00e7\u00f5es de COLLATE e CTYPE podem estar fora da configura\u00e7\u00e3o ideal. N\u00e3o \u00e9 poss\u00edvel alterar essas op\u00e7\u00f5es em bancos j\u00e1 criados. Uma solu\u00e7\u00e3o \u00e9 fazer um backup, criar o banco com as op\u00e7\u00f5es desejadas e restaurar o banco na sequencia. Para deixar as op\u00e7\u00f5es no estado &hellip; <a href=\"https:\/\/rdconsolo.com.br\/?p=127\" class=\"more-link\">Continue lendo<span class=\"screen-reader-text\"> &#8220;Configurar COLLATE e CTYPE no PostgreSQL&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[5],"class_list":["post-127","post","type-post","status-publish","format-standard","hentry","category-developer","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=\/wp\/v2\/posts\/127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=127"}],"version-history":[{"count":2,"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=\/wp\/v2\/posts\/127\/revisions"}],"predecessor-version":[{"id":134,"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=\/wp\/v2\/posts\/127\/revisions\/134"}],"wp:attachment":[{"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rdconsolo.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}