Skip to content

Instantly share code, notes, and snippets.

@joshteng

joshteng/psql_encoding.markdown

Forked from turboladen/psql_encoding.sql
Last active October 31, 2022 19:23
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 4 You must be signed in to fork a gist
  • Save joshteng/9895494 to your computer and use it in GitHub Desktop.
Save joshteng/9895494 to your computer and use it in GitHub Desktop.
Download ZIP
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
Copy link

x011 commented Mar 14, 2021

Thank you so much.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment