Shulou(Shulou.com)06/01 Report--

$ 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.

Reason:

Although version 9.6 of pgsql is installed, the psql script references the older version.

Solution:

Replace the old psql script in the system with the new version.

$ 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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.