{"id":234,"date":"2013-07-01T21:01:00","date_gmt":"2013-07-01T21:01:00","guid":{"rendered":"http:\/\/119@jodohost.com\/\/blog\/"},"modified":"2013-07-01T21:01:00","modified_gmt":"2013-07-01T21:01:00","slug":"how-to-change-postgresql-database-encoding","status":"publish","type":"post","link":"http:\/\/www.jodohost.com\/blog\/index.php\/2013\/07\/01\/how-to-change-postgresql-database-encoding\/","title":{"rendered":"How to change PostgreSQL database encoding"},"content":{"rendered":"<p>To accomplish this task, we need to delete the existing database first and then re-create the same with the required encoding.<\/p>\n<p>Steps:-<br \/>\u00a0 1. Login to the respective PostgreSQL server<br \/>\u00a0 2. su -l postgres<br \/>\u00a0 3. dropdb <databasename><br \/>\u00a0 4. createdb -E UNICODE -O <databaseowner> <databasename><br \/>\u00a0 5. Exit<\/p>\n<p>Note :- If the database contains data, it will be lost. So, it is advisable to take the backup of the database before deletion. After the creation of the database with the required encoding, data can be restored from the backup.<\/p>\n<p> ]]><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To accomplish this task, we need to delete the existing database first and then re-create the same with the required encoding. Steps:-\u00a0 1. Login to the respective PostgreSQL server\u00a0 2. su -l postgres\u00a0 3. dropdb \u00a0 4. createdb -E UNICODE -O \u00a0 5. Exit Note :- If the database contains data, it will be lost. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/234"}],"collection":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=234"}],"version-history":[{"count":0,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/234\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=234"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}