Greg Donald : ignore latin1 problem via psql Page

ignore latin1 problem via psql

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 (3) psql (1)