一、修改配置文件,将端口改为网卡监听,默认本地地址监听,opengauss默认使用sha256加密数据,改为md5
postgresql.conf
listen_addresses = '0.0.0.0';
local_bind_address = '0.0.0.0';
port = 8888;
max_connections = 10000;
password_encryption_type = 0 #Password storage type, 0 is md5 for PG, 1 is sha256 + md5, 2 is sha256 only
二、将访问权限放开,并配置md5可以访问;
pg_hba.conf
host all all 10.145.26.109/32 trust
host all all 0.0.0.0/0 md5
三、修改配置后重启数据库
gs_ctl restart -D /opt/software/openGauss/openGauss-5.1.0-CentOS-64bit/data/single_node
四、导出postgres数据库
postgres导出数据
pg_dump -d dbname >dbname.sql
五、opengauss导入数据
1.创建角色/用户并设置密码
CREATE ROLE ud_base WITH PASSWORD "P@ssw0rd";
alter role "ud_base" with login;
GRANT ALL PRIVILEGES TO ud_base;
CREATE DATABASE ud_base OWNER ud_base;
CREATE ROLE ud_work WITH PASSWORD "P@ssw0rd";
alter role "ud_work" with login;
GRANT ALL PRIVILEGES TO ud_work;
CREATE DATABASE ud_work OWNER ud_work;
2.导入数据
gsql -U 导入用户 -d 导入的目标数据库 -p opengauss服务端口 <postgres导出的数据库
gsql -U ud_base -d ud_base -p 8888 < /opt/software/openGauss/openGauss-5.1.0-CentOS-64bit/testdb.sql
3.启动应用程序即可