Change postgres default template0 to UTF8 encoding

psqlfix.txt

mike@rbci:~$ psql -U postgres
psql (9.0.3)
Type "help" for help.

postgres=# update pg_database set datallowconn = TRUE where datname = 'template0';
UPDATE 1
postgres=# \c template0
You are now connected to database "template0".
template0=# update pg_database set datistemplate = FALSE where datname = 'template1';
UPDATE 1
template0=# drop database template1;
DROP DATABASE
template0=# \q
$ createdb -E UTF8 --lc-collate en_US.UTF-8 --lc-ctype en_US.UTF-8 -T template0 template1
$ psql -c "update pg_database set datistemplate = TRUE where datname = 'template1';"
psql -d template1 -c "update pg_database set datallowconn = FALSE where datname = 'template0';"
UPDATE 1