Comments (5)
抱歉,最近几天一直在病中,无法及时回复。
-
前端这块build使用的内存控制不住……毕竟node的内存策略是尽可能多用少放,这只能后面加个提示了。
-
这个不太了解啊,我从PG 9.5开始使用至今,从来没设置过什么数据库编码。是11.X新版本有变化吗?
from icarus.
第二点。我今天重新在另外一台机器上安装了PG10 发现默认的数据库编码都是 UTF-8的而不是SQL_ASCII。
(我觉得可能跟系统默认编码有关,默认编码是什么安装好PG的默认编码就是什么。)
不过还是加上 “启动遇到 UnicodeEncodeError,检查一下PG数据库的编码" 的提示把。
除此之外没有其他问题了。 感觉作者写的BBS很棒,很简洁并且想要的功能点都有!
from icarus.
emmmm 你原来的系统是啥。我看ubuntu是默认源里没有,添加了PG官方源的话应该是默认建好utf8数据库。
另外archlinux(manjaro)软件源里有pg11,不过装好之后默认没建立数据库,但给出的建立提示也是utf-8的,虽然是en_US.UTF8
[fy@fy-pc ~]$ systemctl status postgresql
● postgresql.service - PostgreSQL database server
Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Fri 2019-02-15 14:27:47 CST; 7s ago
Process: 1462 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGROOT}/data (code=exited, status=1/FAILURE)
2月 15 14:27:47 fy-pc systemd[1]: Starting PostgreSQL database server...
2月 15 14:27:47 fy-pc postgres[1462]: "/var/lib/postgres/data" is missing or empty. Use a command like
2月 15 14:27:47 fy-pc postgres[1462]: su - postgres -c "initdb --locale en_US.UTF-8 -D '/var/lib/postgres/data'"
2月 15 14:27:47 fy-pc postgres[1462]: with relevant options, to initialize the database cluster.
2月 15 14:27:47 fy-pc systemd[1]: postgresql.service: Control process exited, code=exited status=1
2月 15 14:27:47 fy-pc systemd[1]: postgresql.service: Failed with result 'exit-code'.
2月 15 14:27:47 fy-pc systemd[1]: Failed to start PostgreSQL database server.
from icarus.
emmmm 你原来的系统是啥。我看ubuntu是默认源里没有,添加了PG官方源的话应该是默认建好utf8数据库。
另外archlinux(manjaro)软件源里有pg11,不过装好之后默认没建立数据库,但给出的建立提示也是utf-8的,虽然是en_US.UTF8[fy@fy-pc ~]$ systemctl status postgresql ● postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Fri 2019-02-15 14:27:47 CST; 7s ago Process: 1462 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGROOT}/data (code=exited, status=1/FAILURE) 2月 15 14:27:47 fy-pc systemd[1]: Starting PostgreSQL database server... 2月 15 14:27:47 fy-pc postgres[1462]: "/var/lib/postgres/data" is missing or empty. Use a command like 2月 15 14:27:47 fy-pc postgres[1462]: su - postgres -c "initdb --locale en_US.UTF-8 -D '/var/lib/postgres/data'" 2月 15 14:27:47 fy-pc postgres[1462]: with relevant options, to initialize the database cluster. 2月 15 14:27:47 fy-pc systemd[1]: postgresql.service: Control process exited, code=exited status=1 2月 15 14:27:47 fy-pc systemd[1]: postgresql.service: Failed with result 'exit-code'. 2月 15 14:27:47 fy-pc systemd[1]: Failed to start PostgreSQL database server.
我第一次用的ubuntu16.04试的。第二次 换了一台机器也是ubuntu16.04的。但是第一次默认是ASCII 第二次是换一台以及一样系统是UTF-8
from icarus.
终于遇到了类似案例,这次是18.04
解决方案:
update pg_database set encoding = pg_char_to_encoding('UTF8') where datname = 'icarus';
from icarus.
Related Issues (20)
- 安装了qiniu 还是 报错 No module named 'qiniu' HOT 1
- 有没有后端API文档 HOT 1
- 希望能有一份开发文档支持 HOT 1
- 在不开启ngix的情况下,如何解决跨域问题呢 HOT 2
- netapi.js?a2e6:32 OPTIONS http://192.168.1.105:9999/api/misc/info net::ERR_CONNECTION_REFUSED HOT 3
- 感谢楼主提供如此优秀的代码 HOT 2
- 希望支持匿名发帖和评论 HOT 2
- 点击@的人 不跳转到对方个人资料页面去?
- 希望出一个关注功能
- 编译后icon无法正常展示
- 建议使用sqlalchemy框架以支持不同数据库需求
- Can't resolve '../private.js'
- Add translations? HOT 3
- 启动后端服务时报错 ImportError: cannot import name 'EMPTY_PERMISSION'` HOT 4
- 做个docker镜像吧 HOT 1
- 注册一直报错
- 启动报错 HOT 6
- Windows下验证错误但用户已创建且已更改密码 HOT 1
- 希望支持mysql数据库 HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from icarus.