一、概述
先配置远程访问,再配置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;
标签:gs,database,0.0,create,keepalived,建库建,joe,opengauss,远程
From: https://blog.51cto.com/u_13236892/6210558