gsql常见问题

 

gs_initdb -W Gauss_234 -D /media/sdc/wxy/install/data --nodename='datanode'

gs_ctl restart -D /media/sdc/wxy/install/data -Z single_node -l logfile

 

 gs_initdb -D /media/sdc/wxy/install/data --nodename='datanode'

没有-W参数，需要alter role wxy password 'Gauss_234';

 

gsql: expected authentication request from server, but received v

因为端口号的原因，5432d的端口号是别的用户的，需要更改一下端口号。

比如5442，在data/postgresql.conf文件中修改一下port参数。

 

ERROR: Please use "ALTER ROLE "wxy" PASSWORD 'password';" to set the password of the user before other operations!

 

 

 

 top -n 1 -H -p `ps xf | grep gaussdb| grep -v grep |awk '{print $1}'`|grep 'worker'

 

 

top -n 1 -H -p `ps xf | grep gaussdb| grep -v grep |awk '{print $1}'`|grep -w 'worker'|awk '{print $1}'

 

 

 

 

 

linux控制台出现了

-bash-4.2$

因为.bashrc缺失了

# .bashrc

# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi