Postgresql UTF-8

Postgresql UTF-8

# sudo su - postgres
# createuser -s -r vagrant
# psql
# UPDATE pg_database SET datistemplate=FALSE WHERE datname='template1';
# DROP DATABASE template1;
# CREATE DATABASE template1 WITH owner=postgres encoding='UTF-8'

  lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;

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