id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
18710	new encoding (UTF8) is incompatible with the encoding of the template database	anonymous	nobody	"createdb my_prod -E UTF8 -T template0

createdb: database creation failed: ERROR:  new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
HINT:  Use the same encoding as in the template database, or use template0 as template.
createdb: database creation failed: ERROR:  new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)HINT:  Use the same encoding as in the template database, or use template0 as template.

=====
use the following instead:

createdb template_postgis -E UTF8 -T template0

"	Uncategorized	closed	Documentation	1.4	Normal	invalid			Unreviewed	0	0	0	0	0	0