Category Archives: SQL

postgresql LC_CTYPE error

Posted on October 4, 2014 by gringao

When I was installing an app who used PostGreSQL I got this error : DataError: encoding “UTF8” does not match locale “en_US” DETAIL: The chosen LC_CTYPE setting requires encoding “LATIN1”. Here is the solution : /etc/init.d/postgresql-9.3 stop pg_dropcluster –stop 9.3 … Continue reading →