[highgo@db2 data]$ psql -p 5866
psql: 致命错误: 角色 "highggo" 不存在
[highgo@db2 data]$ cd
[highgo@db2 ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export HG_HOME=/hg/hgdb/3.1.4
export PGUSER=highggo 《---此处为人为配置错误导致
export PGPORT=5866
export PGDATA=$HG_HOME/data
export PGPOOL=/hg/cluster/pgpool/3.6.4
export PATH=$HG_HOME/bin:$PGPOOL/bin:$PATH:$HOME/bin
export LD_LIBRARY_PATH=$HG_HOME/lib:$PGPOOL/lib:$LD_LIBRARY_PATH
[highgo@db2 ~]$
更改后:
[highgo@db2 ~]$ echo $PGUSER
highgo
[highgo@db2 ~]$ source .bash_profile
[highgo@db2 ~]$ psql -p 5866
psql (3.1.4)
Type "help" for help.
highgo=# \q
psql: 致命错误: 角色 "highggo" 不存在
[highgo@db2 data]$ cd
[highgo@db2 ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export HG_HOME=/hg/hgdb/3.1.4
export PGUSER=highggo 《---此处为人为配置错误导致
export PGPORT=5866
export PGDATA=$HG_HOME/data
export PGPOOL=/hg/cluster/pgpool/3.6.4
export PATH=$HG_HOME/bin:$PGPOOL/bin:$PATH:$HOME/bin
export LD_LIBRARY_PATH=$HG_HOME/lib:$PGPOOL/lib:$LD_LIBRARY_PATH
[highgo@db2 ~]$
更改后:
[highgo@db2 ~]$ echo $PGUSER
highgo
[highgo@db2 ~]$ source .bash_profile
[highgo@db2 ~]$ psql -p 5866
psql (3.1.4)
Type "help" for help.
highgo=# \q