postgresql LC_CTYPE error

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 main
pg_createcluster --locale en_US.UTF-8 --start 9.3 main
/etc/init.d/postgresql-9.3 start

This entry was posted in IT, Linux, SQL. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.