OpenGauss 单机版安装
银河麒麟的前置事项
yum -y install libaio-devel flex bison ncurses-devel glibc-devel patch readline-devel openssl-devel sqlite-devel libnsl bzip2 net-tools
sysctl -w kernel.sem="250 85000 250 330"
创建用户信息:
groupadd dbgroup
useradd -g dbgroup omm
passwd omm
mkdir -p /usr/openGauss
cat >/etc/profile.d/opengauss.sh << EOF
export GAUSSHOME=/usr/openGauss/bin
export LD_LIBRARY_PATH=\$GAUSSHOME/lib::\$LD_LIBRARY_PATH
export PATH=\$GAUSSHOME/bin:$PATH
export GAUSSLOG=\$GAUSSHOME/bin/log
EOF
source /etc/profile.d/opengauss.sh
sed -i '/omm/d' /etc/sudoers
echo "omm ALL=(ALL) NOPASSWD: ALL" >> /etc/sudoers
下载并且解压缩
https://opengauss.obs.cn-south-1.myhuaweicloud.com/3.0.5/x86/openGauss-3.0.5-CentOS-64bit.tar.bz2
tar -jxvf openGauss-3.0.5-openEuler-64bit.tar.bz2 -C /usr/openGauss/
chown -R omm:dbgroup /usr/openGauss
初始化
su - omm
cd /usr/openGauss/simpleInstall
sh install.sh -w "Testxxxxxxxx"
启动数据库:
gs_ctl restart -D $GAUSSHOME/data/single_node -Z single_node
修改配置:
vim /usr/openGauss/data/single_node/pg_hba.conf
增加:
host all all 0.0.0.0/0 md5
vim /usr/openGauss/data/single_node/postgresql.conf
listen_addresses = '*'
local_bind_address = '0.0.0.0'
port = 5432
max_connections = 1000
ssl = off
password_encryption_type = 0
重启数据库
gs_ctl restart -D $GAUSSHOME/data/single_node -Z single_node
创建用户
gsql -d postgres
CREATE USER root PASSWORD 'Testxxxxxxxx';
GRANT ALL PRIVILEGES TO root;
alter role root sysadmin;
\q
navicat连接
db postgres
user root
password
登录连接即可.
需要注意如果 创建密码的时候 如果没有设置密码 md5 后者是 sha1 需要重新修改密码
alter user root identified by 'Testxxxxxxxx';
注意这个地方是有一些差异的. 密码不允许重复, 安全级别比较高一些.