$ psql -U peimsmdata -h 127.0.0.1 peimsm
could not change directory to "/root"
Password for user peimsmdata:
psql (9.2.23, server 9.6.3)
WARNING: psql version 9.2, server version 9.6.
Some psql features might not work.
Type "help" for help.
原因:
虽然系统安装了9.6版本的pgsql,但是psql这个脚本却引用了旧的版本。
解决方法:
替换系统中旧版本的psql脚本为新的版本。
$ psql --version
could not change directory to "/root"
psql (PostgreSQL) 9.2.23
# which -a psql
/usr/bin/psql
/usr/local/postgresql/bin/psql
/bin/psql
# mv /usr/bin/psql /usr/bin/psql.bak
# ln -s /usr/local/postgresql/bin/psql /usr/bin/psql
$ psql -U peimsmdata -h 127.0.0.1 peimsm
could not change directory to "/root": Permission denied
Password for user peimsmdata:
psql (9.6.3)
Type "help" for help.