MySQL数据库迁移瀚高数据库

1.瀚高数据库安装
下载Highgo Database安全版rpm包并上传至服务器，使用如下命令进行安装
rpm -ivh hgdb5.6.4-enterprise-rhel7.x-x86-64-20190723.rpm
配置环境变量
vim ~/.bash_profile
export PATH
export HG_BASE=/opt/HighGo6.0.1-cluster
export PGHOME=/opt/HighGo6.0.1-cluster
export HGDB_HOME=/opt/HighGo6.0.1-cluster
export PGDATA=/opt/HighGo6.0.1-cluster/data
export LD_LIBRARY_PATH=/opt/HighGo6.0.1-cluster/lib:$LD_LIBRARY_PATH
export PATH=$PATH:/opt/HighGo6.0.1-cluster/bin
初始化数据库
initdb -D /opt/HighGo6.0.1-cluster/data
启动数据库
pg_ctl -D /opt/HighGo6.0.1-cluster/data start
修改配置
vim /opt/HighGo6.0.1-cluster/data/pg_hba.conf
增加
host all all 0.0.0.0/0 md5

vim /opt/HighGo6.0.1-cluster/data/postgresql.conf
listen_addresses前边#去掉，参数值改

重新启动数据库
pg_ctl -D /opt/HighGo6.0.1-cluster/data restart

防火墙开放数据库默认端口:5866