joshteng/psql_encoding.markdown

Forked from turboladen/psql_encoding.sql

Last active October 31, 2022 19:23

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/joshteng/9895494.js"></script>
Save joshteng/9895494 to your computer and use it in GitHub Desktop.

This solves Postgresql's encoding issue (happened to me when running postgres on my vagrant box) The error happens when trying to create db "rake db:create": Error message: "encoding UTF8 does not match locale en_US; the chosen LC_CTYPE setting requires encoding LATIN1"

Raw

psql_encoding.markdown

    sudo su postgres
psql
update pg_database set datistemplate=false where datname='template1';
drop database Template1;
create database template1 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;
update pg_database set datistemplate=true where datname='template1';
\q
exit

  

x011 commented Mar 14, 2021

Thank you so much.