<?xml version="1.0" encoding="UTF-8"?>
<ROOT>
  <!-- 整體信息 -->
  <CLUSTER>
  <!-- 數(shù)據(jù)庫名稱 -->
    <PARAM name="clusterName" value="opengauss" />
  <!-- 數(shù)據(jù)庫節(jié)點名稱(hostname) -->
    <PARAM name="nodeNames" value="localhost.localdomain" />
  <!-- 節(jié)點IP，與nodeNames一一對應 -->
    <PARAM name="backIp1s" value="192.168.44.129"/>
  <!-- 數(shù)據(jù)庫安裝目錄-->
    <PARAM name="gaussdbAppPath" value="/opt/huawei/install/app" />
  <!-- 日志目錄-->
    <PARAM name="gaussdbLogPath" value="/var/log/omm" />
  <!-- 臨時文件目錄-->
    <PARAM name="tmpMppdbPath" value="/opt/huawei/tmp" />
  <!--數(shù)據(jù)庫工具目錄-->
    <PARAM name="gaussdbToolPath" value="/opt/huawei/install/om" />
  <!--數(shù)據(jù)庫core文件目錄-->
    <PARAM name="corePath" value="/opt/huawei/corefile"/>
  <!-- openGauss類型，此處示例為單機類型，“single-inst”表示單機一主多備部署形態(tài)-->
    <PARAM name="clusterType" value="single-inst"/>
  </CLUSTER>
  <!-- 每臺服務器上的節(jié)點部署信息 -->
  <DEVICELIST>
      <!-- node1上的節(jié)點部署信息 -->
      <DEVICE sn="1000001">
          <!-- node1的hostname -->
          <PARAM name="name" value="localhost.localdomain"/>
          <!-- node1所在的AZ及AZ優(yōu)先級 -->
          <PARAM name="azName" value="AZ1"/>
          <PARAM name="azPriority" value="1"/>
          <!-- node1的IP，如果服務器只有一個網(wǎng)卡可用，將backIP1和sshIP1配置成同一個IP -->
          <PARAM name="backIp1" value="192.168.44.129"/>
          <PARAM name="sshIp1" value="192.168.44.129"/>
          <!--DBnode-->
          <PARAM name="dataNum" value="1"/>
          <!--DBnode端口號-->
          <PARAM name="dataPortBase" value="26000"/>
          <!--DBnode主節(jié)點上數(shù)據(jù)目錄，及備機數(shù)據(jù)目錄-->
          <PARAM name="dataNode1" value="/opt/huawei/install/data/db1"/>
          <!--DBnode節(jié)點上設定同步模式的節(jié)點數(shù)-->
          <!--><PARAM name="dataNode1_syncNum" value="0"/><-->
      </DEVICE>
  </DEVICELIST>
</ROOT>

export LD_LIBRARY_PATH=/srv/yutu/opengauss/script/gspylib/clib:$LD_LIBRARY_PATH
export GPHOME=/opt/huawei/install/om
export PATH=$GPHOME/script/gspylib/pssh/bin:$GPHOME/script:$PATH
export LD_LIBRARY_PATH=$GPHOME/script/gspylib/clib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH=$GPHOME/lib:$LD_LIBRARY_PATH
export PYTHONPATH=$GPHOME/lib

host all all 192.168.56.1/32 md5
host all all 0.0.0.0/0 md5

1.listen_addresses = '*'
2.local_blind_address = '0.0.0.0'
3.將password_encrytion_type前面的#刪除，并且將其賦值為0
password_encrytion_type = 0

[omm@opengauss root]$ gsql -d postgres -p 26000
openGauss=# create user test with password "test@123";
CREATE ROLE
openGauss=# GRANT ALL PRIVILEGES to test;
ALTER ROLE
openGauss=# create database hjl owner test;
CREATE DATABASE
openGauss=# \l
                          List of databases
   Name    | Owner | Encoding  | Collate | Ctype | Access 
privileges 
-----------+-------+-----------+---------+-------+--------
-----------
 db_tpcc   | test  | SQL_ASCII | C       | C     | 
 postgres  | omm   | SQL_ASCII | C       | C     | 
 template0 | omm   | SQL_ASCII | C       | C     | =c/omm 
          +
           |       |           |         |       | omm=CTc
/omm
 template1 | omm   | SQL_ASCII | C       | C     | =c/omm 
          +
           |       |           |         |       | omm=CTc
/omm
(4 rows)
[omm@opengauss root]$ gsql -d db_tpcc -p 26000 -U test
Password for user test: 

db_tpcc=> create table mytable(firstcol int);
CREATE TABLE
db_tpcc=> insert into mytable values (100);
INSERT 0 1
db_tpcc=> select * from mytable;
 firstcol 
----------
      100
(1 row)

db_tpcc=> \q