瀚高数据库搭建

操作系统：Centos7
安装介质：hgdb6.0.1-enterprise-centos7-x86-64-20201020.rpm
说明：实践操作是在Centos7.7.1908中配置，亲测有效，本文仅供参考。

---

不多说直接开整

一、安装

    将安装介质上传到/opt目录中

rpm -ivh hgdb6.0.1-enterprise-centos7-x86-64-20201020.rpm 

 

二、环境配置

su - highgo
mkdir -p /opt/HighGo6.0.1-cluster/data

   cat  /opt/HighGo6.0.1-cluster/etc/highgodb.env        --查看hgdb提供的环境变量，并添加到环境变量中

vi /home/highgo/.bash_profile

export LD_LIBRARY_PATH=/usr/lib64:/opt/HighGo6.0.1-cluster/lib:$LD_LIBRARY_PATH
export HGDB_HOME=/opt/HighGo6.0.1-cluster
export HG_BASE=/opt/HighGo6.0.1-cluster
export PGPORT=5866
export PGDATA=/opt/HighGo6.0.1-cluster/data

 

    source /home/highgo/.bash_profile    --使环境变量立即生效

三、初始化数据库

su - highgo

initdb -D /opt/HighGo6.0.1-cluster/data

  输入两遍特别繁琐的密码后初始化完成，密码竟然还不能带有  "_" 或 "-" 真的胃疼。

四、启动

pg_ctl -D /opt/HighGo6.0.1-cluster/data -l logfile start

五、创建数据库、用户

 

highgo=# create database dbname owner highgo; 
CREATE DATABASE
highgo=# grant all on database dbname to highgo; 
GRANT

highgo-# \c dbname

PSQL: Release 6.0.1
You are now connected to database "dbname" as user "highgo".
dbname=# CREATE ROLE "username1" login PASSWORD 'Test123!@#' SUPERUSER CREATEDB CREATEROLE;
CREATE ROLE

dbname=# CREATE ROLE "username2" login PASSWORD 'Test123!@#' SUPERUSER CREATEDB CREATEROLE;
CREATE ROLE

dbname=# CREATE ROLE "username3" login PASSWORD 'Test123!@#' SUPERUSER CREATEDB CREATEROLE;
CREATE ROLE
dbname=# 

   需要注意的是，用户名的密码中不能带有数据库名、用户名