Change postgres default template0 to UTF8

gistfile1.txt

psql -U postgres

#> update pg_database set datallowconn = TRUE where datname = 'template0';
#> \c template0
#> update pg_database set datistemplate = FALSE where datname = 'template1';
#> drop database template1;
#> create database template1 with template = template0 encoding = 'UTF8';
#> update pg_database set datistemplate = TRUE where datname = 'template1';
#> \c template1
#> update pg_database set datallowconn = FALSE where datname = 'template0';