POSTGRESQL DEFAULT Template0наutf8 ENCODING

Dataerror:new encoding (UTF8) is incompatible and the encoding of the template database (SQL_ASCII) HINT: Use the  sam E encoding as in the template database, or use TEMPLATE0 as template.

　　

[Email protected]:~# su postgres[email protected]:~ $ psql-u postgrespsql (9.0.3) Type ' help ' for help.postgres=# update p G_database Set datallowconn = TRUE where datname = ' template0 '; Update 1postgres=# \c Template0you is now connected to database "Template0". template0=# Update Pg_database Set Datistempl ate = FALSE where datname = ' template1 '; UPDATE 1template0=# drop Database template1;drop databasetemplate0=# CREATE database template1 with template = Template0 E ncoding = ' UTF8 '; CREATE databasetemplate0=# Update pg_database Set datistemplate = TRUE where datname = ' template1 '; Update 1template0=# \c Template1you is now connected to database "Template1". template1=# Update Pg_database Set DATALLOWC Onn = FALSE where datname = ' template0 '; UPDATE 1template1= #Ctrl +z[email protected]:~ $ exit[email protected]:~#

　　

POSTGRESQL DEFAULT Template0наutf8 ENCODING