openGauss6.0LTS单点企业版部署_内核能力实践

<?xml version="1.0" encoding="UTF-8"?>
<ROOT>
  <!-- openGauss整体信息 -->
  <CLUSTER>
    <!-- 数据库名称 -->
    <PARAM name="clusterName" value="dbCluster" >
    <!-- 数据库节点名称(hostname) -->
    <PARAM name="nodeNames" value="node1_hostname" >
    <!-- 数据库安装目录-->
    <PARAM name="gaussdbAppPath" value="/opt/huawei/install/app" >
    <!-- 日志目录-->
    <PARAM name="gaussdbLogPath" value="/var/log/omm" />
    <!-- 临时文件目录-->
    <PARAM name="tmpMppdbPath" value="/opt/huawei/tmp" />
    <!-- 数据库工具目录-->
    <PARAM name="gaussdbToolPath" value="/opt/huawei/install/om" />
    <!-- 数据库core文件目录-->
    <PARAM name="corePath" value="/opt/huawei/corefile" />
    <!-- 节点IP，与数据库节点名称列表一一对应 -->
    <!-- 如果用ipv6 替换ipv4地址即可 如：<PARAM name="backIp1s" value="2407:xxxx:xxxx:xxxx:xxxx:xxxx:caa:2335"/> -->
    <PARAM name="backIp1s" value="192.168.0.1"/> 
  </CLUSTER>
  <!-- 每台服务器上的节点部署信息 -->
  <DEVICELIST>
    <!-- 节点1上的部署信息 -->
    <DEVICE sn="node1_hostname">
      <!-- 节点1的主机名称 -->
      <PARAM name="name" value="node1_hostname"/>
      <!-- 节点1所在的AZ及AZ优先级 -->
      <PARAM name="azName" value="AZ1"/>
      <PARAM name="azPriority" value="1"/>
      <!-- 节点1的IP，如果服务器只有一个网卡可用，将backIP1和sshIP1配置成同一个IP -->
      <!-- 用ipv6安装部署时 换上ipv6地址即可，后面xml文件示例也是同样操作 -->
      <PARAM name="backIp1" value="192.168.0.1"/>
      <PARAM name="sshIp1" value="192.168.0.1"/>


      <!--dbnode-->
      <PARAM name="dataNum" value="1"/>
      <PARAM name="dataPortBase" value="15400"/>
      <PARAM name="dataNode1" value="/opt/huawei/install/data/dn"/>
      <PARAM name="dataNode1_syncNum" value="0"/>
    </DEVICE>
  </DEVICELIST>
</ROOT>

CREATE OR REPLACE PROCEDURE nested_cursor_example()
LANGUAGE plpgsql
AS $$
DECLARE
    outer_cursor CURSOR FOR SELECT id FROM outer_table;
    inner_cursor CURSOR FOR SELECT name FROM inner_table WHERE id = outer_id;
BEGIN
    OPEN outer_cursor;
    LOOP
        FETCH outer_cursor INTO outer_id;
        EXIT WHEN NOT FOUND;


        OPEN inner_cursor;
        LOOP
            FETCH inner_cursor INTO inner_name;
            EXIT WHEN NOT FOUND;
            -- 处理inner_name
        END LOOP;
        CLOSE inner_cursor;
    END LOOP;
    CLOSE outer_cursor;
END;
$$;

CREATE OR REPLACE PROCEDURE dynamic_cursor_example(OUT ref_cursor REFCURSOR)
LANGUAGE plpgsql
AS $$
BEGIN
    OPEN ref_cursor FOR SELECT * FROM some_table;
END;
$$;

CREATE OR REPLACE PROCEDURE create_procedure_ignore_dependencies()
LANGUAGE plpgsql
AS $$
BEGIN
    -- 存储过程逻辑
END;
$$;

CREATE OR REPLACE FUNCTION pipelined_function()
RETURNS SETOF some_table AS $$
BEGIN
    FOR record IN SELECT * FROM some_table LOOP
        RETURN NEXT record;
    END LOOP;
    RETURN;
END;
$$ LANGUAGE plpgsql;

SELECT * FROM (
  SELECT * FROM some_table
) AS rotated_table ROTATE (1); -- 将第一列旋转到最后