POSTGRESQL DEFAULT TEMPLATE0 НА UTF8 ENCODING

標籤：

 

DataError: 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.

　　

[email protected]:~# su postgres[email protected]:~ $ psql -U postgrespsql (9.0.3)Type "help" for help.postgres=# update pg_database set datallowconn = TRUE where datname = ‘template0‘;UPDATE 1postgres=# \c template0You are now connected to database "template0".template0=# update pg_database set datistemplate = FALSE where datname = ‘template1‘;UPDATE 1template0=# drop database template1;DROP DATABASEtemplate0=# create database template1 with template = template0 encoding = ‘UTF8‘;CREATE DATABASEtemplate0=# update pg_database set datistemplate = TRUE where datname = ‘template1‘;UPDATE 1template0=# \c template1You are now connected to database "template1".template1=# update pg_database set datallowconn = FALSE where datname = ‘template0‘;UPDATE 1template1=#Ctrl+Z[email protected]:~ $ exit[email protected]:~#

　　

POSTGRESQL DEFAULT TEMPLATE0 НА UTF8 ENCODING