基于docker搭建瀚高数据库HighGo6.0.1【图文】

docker部署
https://blog.csdn.net/weixin_44385419/article/details/127738868

拉取镜像

docker pull xuxuclassmate/highgo

启动

docker run --name highgo --privileged=true -p 5866:5866 -d xuxuclassmate/highgo
或者
docker run --name highgo --privileged=true -p 5866:5866 -v ~/docker/highgo/data:/opt/HighGo6.0.1-cluster/data -e HIGHGO_PASSWORD=Highgo@12345 -d xuxuclassmate/highgo

验证

docker ps

进入容器

ff7bcd35b408 对应的id

docker exec -it ff7bcd35b408 /bin/bash

登录数据库

默认账号 ： highgo
默认密码 ：Highgo@123

./opt/HighGo6.0.1-cluster/bin/runpsql.sh

vim ./opt/HighGo6.0.1-cluster/bin/runpsql.sh此命令为进入瀚高数据，不过默认的highgo没有sysdba角色。取消了角色
LD_LIBRARY_PATH=/opt/HighGo6.0.1-cluster/lib:$LD_LIBRARY_PATH /opt/HighGo6.0.1-cluster/bin/psql -h localhost -p 5866 -U highgo

查看数据库加密方式

 show password_encryption;

修改加密方式为sm3

cd ./opt/HighGo6.0.1-cluster/data/
vim pg_hba.conf

vim postgresql.conf

进入数据库修改密码

set password_encryption TO sm3;
alter user current_user password 'newpwd';

密码：
长度至少8位及以上
至少一个大写字母
至少一个小写字母
至少一个特殊符号
至少一个号码

重启容器

重启容器，重启数据库也可以，容器重启方便些

数据库验证

   <!-- 瀚高驱动包-->
   <dependency>
       <groupId>com.highgo</groupId>
       <artifactId>HgdbJdbc</artifactId>
       <version>6.2.2</version>
   </dependency>

jdbc.driverClassName = com.highgo.jdbc.Driver
jdbc.url = jdbc:highgo://ip:5866/highgo?useUnicode=true&characterEncoding=utf8&currentSchema=public&stringtype=unspecified
jdbc.username = highgo
jdbc.password = newpwd

加密方式修改为sm3之后pg的驱动包，驱动方式无法连接瀚高
报错：The authentication type 13 is not supported. Check that you have configured the pg_hba.conf file to include the client’s IP address or subnet, and that it is using an authentication scheme supported by the driver.
换成瀚高的驱动包

数据库密码到期

密码有效期是七天

查看密码有效期：select show_secure_param();

到期后会报错：Your password has expired, please alter the password.

这个时候登陆docker容器，登陆到数据库中
alter user highgo valid until ‘2099-12-31’;
将此用户密码过期时间延长

延长到一年时间：select set_secure_param('hg_idcheck.pwdvaliduntil','365');

参考

https://blog.csdn.net/XuXuClassMate/article/details/135328250
https://blog.csdn.net/pg_hgdb/article/details/121637550