Make PostgreSQL default to UTF-8

From here :
UPDATE pg_database SET datistemplate=FALSE WHERE datname='template1';


DROP DATABASE template1;
CREATE DATABASE template1 WITH owner=postgres template=template0 encoding='UTF8';

UPDATE pg_database SET datistemplate=TRUE WHERE datname='template1';