linux安装瀚高数据库

1.下载企业版安装包(需注册)

https://www.highgo.com/down_main.html

2.前置操作

###防火墙设置
firewall-cmd --permanent --add-port=5866/tcp

#重载生效
firewall-cmd --reload 

#查看是否开放5866端口
firewall-cmd --list-ports | grep 5866 

###检查时区
timedatectl
请确保操作系统时间无误，且时区为上海时区（或者香港时区）

//修改时区为上海
timedatectl set-timezone Asia/Shanghai

###
创建highgo用户
groupadd -g 5866 highgo
useradd -u 5866 -g highgo highgo; echo xxx | passwd -f --stdin highgo （此处密
码和密码管理员确认,xxx为要使用的密码）

3.上传rpm包并进行安装

mv 1b73693f2c91fd7f38acbc7d3882cf6c.rpm hg.rpm

rpm -ivh hg.rpm

 4.配置环境变量

cat /opt/HighGo6.0.4-cluster/etc/highgodb.env 

export HG_BASE=/opt/HighGo6.0.4-cluster
export HGDB_HOME=/opt/HighGo6.0.4-cluster
export PGPORT=5866
export PGDATABASE=highgo
export PGDATA=$HGDB_HOME/data
export PATH=$HGDB_HOME/bin:$PATH

将以上内容全部添加至/etc/profile文件中,可根据自己实际情况进行修改

source /etc/profile

5.初始化数据库

su highgo

cd /opt/HighGo6.0.4-cluster/bin/

mkdir /opt/HighGo6.0.4-cluster/data

./initdb 

6.修改配置文件并启动

cd /opt/HighGo6.0.4-cluster/data

vi postgresql.conf 

listen_addresses = '*'
port = 5866
max_connections = 1024
ssl = off

vi pg_hba.conf 

host    all             all             0.0.0.0/0            md5

cd /opt/HighGo6.0.4-cluster/bin

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

7.进入到bin目录下创建数据库

./psql -U highgo

highgo=# create database testdb owner highgo;
CREATE DATABASE

8.进行连接测试