一、概述
先配置远程访问,再配置keepalived,是因为keepalived脚本检测opengauss重启不存活就会挂掉
二、配置远程访问
gs_guc set -I all -N all -c "listen_addresses='0.0.0.0'"
gs_guc set -I all -N all -h "host all all 0.0.0.0/0 sha256"
gs_om -t restart
#第一条配置是为了后续配置keepalived的VIP监听
#第二条配置开放远程访问
三、创建用户等信息
su - omm
gsql -d postgres -p 26000 -r
create user joe with password 'Mysql@123456';
create database database_test with owner joe encoding 'utf8' dbcompatibility='B';
c database_test
create schame joe authrization joe;
服务器托管,北京服务器托管,服务器租用 http://www.fwqtg.net
机房租用,北京机房租用,IDC机房托管, http://www.e1idc.net