Skip to content

Instantly share code, notes, and snippets.

@ajepe
Forked from joshteng/psql_encoding.markdown
Created August 8, 2018 10:44
Show Gist options
  • Save ajepe/e9e41ad0b56920cfedb3b00b94079f2b to your computer and use it in GitHub Desktop.
Save ajepe/e9e41ad0b56920cfedb3b00b94079f2b 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"
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
@ajepe
Copy link
Author

ajepe commented Aug 8, 2018

This just saved

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