首页 > 数据库技术 > 详细

POSTGRESQL DEFAULT TEMPLATE0 НА UTF8 ENCODING

时间:2015-04-19 11:29:53      阅读:450      评论:0      收藏:0      [点我收藏+]

 

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.

  

root@server:~# su postgres
postgres@server:~ $ 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=# create database template1 with template = template0 encoding = ‘UTF8‘;
CREATE DATABASE
template0=# update pg_database set datistemplate = TRUE where datname = ‘template1‘;
UPDATE 1
template0=# \c template1
You are now connected to database "template1".
template1=# update pg_database set datallowconn = FALSE where datname = ‘template0‘;
UPDATE 1
template1=#


Ctrl+Z
postgres@server:~ $ exit
root@server:~#

  

POSTGRESQL DEFAULT TEMPLATE0 НА UTF8 ENCODING

原文:http://www.cnblogs.com/odoo/p/4438772.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!