PostgreSQL创建数据库报错ERROR: new encoding (UTF8) is incompatible with the encoding of the template datab

运行创建数据库时报错

ERROR:  new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)

解决方法：

依次运行以下SQL脚本

update pg_database set datallowconn = TRUE where datname = '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';

update pg_database set datallowconn = FALSE where datname = 'template0';