瀚高:
1、数据库安装
rpm -ivh hgdb5.6.4-enterprise-rhel7.x-86-64.rpm
1.1、启动数据库 systemctl start hgdb-se5.6.4.service
1.2、开放服务器端口
systemctl start firewalld
firewall-cmd --zone=public --add-port=5866/tcp --permanent
firewalld-cmd reload
1.3、修改postgresql.conf文件(/opt/HighGoDB-5.6.4/data)
listen_addressed='*'
port=5866
1.4、修改pg_hba.conf文件(/opt/HighGoDB-5.6.4/data)
#IPv4添加
host all all 0.0.0.0/0 trust
#replication privilege
host replication all 0.0.0.0/0 trust
1.5、重启highgo
systemctl restart hgdb-se5.6.4.service
瀚高默认用户highgo/highgo@123
2、备份
工具:JschUtil
命令:echo 瀚高用户密码|sudo -S su - highgo -c 'PGPASSWORD=highgo pg_dump -h127.0.0.1 -p5866 -dbasename -f $HOME/aaa.sql -uhighgo'
3、还原