ignore latin1 problem via psql

October 20, 2016

CREATE DATABASE _
WITH ENCODING 'UTF8'
OWNER _
LC_COLLATE 'en_US.UTF-8'
LC_CTYPE 'en_US.UTF-8'
TEMPLATE template0;

In the case of a missing en_US.UTF-8 locale, modify /etc/locale.gen to add it, run locale-gen to generate it, then restart Postgres.

postgresql psql