psql- 致命错误 角色 highggo 不存在

来源:互联网 发布:memcached php 编辑:程序博客网 时间:2024/06/06 14:15
[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
原创粉丝点击