Set postgresql template1 default charset to UTF-8

gistfile1.txt

# open console as postgres user
sudo -u postgres psql

# paste this
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';