Change postgres default template0 to UTF8 encoding

f.sql

-- psql -f f.sql

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';