如果用户提供非英语密码，PostgreSQL 安装会中断

Question

好像superuser密码不能接受非英文字符？

Answer 1

否 - utf 密码对于 postgres 来说是完全可以的:

t=# create user so superuser password 'де́льта, греч. δέλτα)';
CREATE ROLE
Time: 112.705 ms
t=# \q
MacBook-Air:~ vao$ export PGPASSWORD="де́льта, греч. δέλτα)" && psql -h 192.168.8.110 t -U so
Timing is on.
psql (9.6.1, server 9.6.3)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.

t=# \q