數(shù)據(jù)庫命令找不到的可能性原因及解決方法

1、問題描述

$ psql
bash: psql: command not found...

安裝完數(shù)據(jù)庫后，無法使用數(shù)據(jù)庫命令

2、問題原因

未設(shè)置環(huán)境變量
環(huán)境變量錯(cuò)誤
數(shù)據(jù)庫安裝失敗

3、解決方案

(1) 未設(shè)置環(huán)境變量

命令所在的路徑需要配置在環(huán)境變量配置文件中。才能調(diào)用
查看是否能夠查找到psql

$ which psql
/usr/bin/which: no psql in (/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/hgdb565/.local/bin:/home/hgdb565/bin)

沒有psql命令
設(shè)置正確環(huán)境變量

export HGDB_HOME=/opt/HighGo5.6.5
export PATH=$PATH:$HGDB_HOME/bin

能夠查找到psql

$ which psql
/opt/HighGo5.6.5/bin/psql

(2) 環(huán)境變量錯(cuò)誤

設(shè)置環(huán)境變量時(shí)。命令所在的路徑設(shè)置錯(cuò)誤，會(huì)導(dǎo)致無法找到相應(yīng)命令

export PGHOME=/opt/HighGo5.6.5/hgdb
export PATH=$PATH:$PGHOME/bin

查找命令，在環(huán)境變量配置中找不到psql

$ which psql
/usr/bin/which: no psql in (/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/hgdb565/.local/bin:/home/hgdb565/bin:/opt/HighGo5.6.5/hgdb/bin)

設(shè)置正確環(huán)境變量

export HGDB_HOME=/opt/HighGo5.6.5
export PATH=$PATH:$HGDB_HOME/bin

能夠查找到psql

$ which psql
/opt/HighGo5.6.5/bin/psql

(3) 數(shù)據(jù)庫安裝失敗

設(shè)置正確環(huán)境變量

export HGDB_HOME=/opt/HighGo5.6.5
export PATH=$PATH:$HGDB_HOME/bin

查找命令，無psql

$ which psql
/usr/bin/which: no psql in (/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/hgdb565/.local/bin:/home/hgdb565/bin:/opt/HighGo5.6.5/bin)

查找對應(yīng)的文件，無此文件

$ ls -atl /opt/HighGo5.6.5/bin/psql
ls: cannot access /opt/HighGo5.6.5/bin/psql: No such file or directory

說明數(shù)據(jù)庫沒有正確安裝，數(shù)據(jù)庫正常安裝后，相應(yīng)的命令調(diào)用程序都會(huì)存放在安裝目錄的bin下。