GBase 8c 管理员指南 南大通用数据技术股份有限公司 8 例如: [gbase@gbase8c ~]$ gs_check -U gbase -i CheckClusterState Parsing the check items config file successfully Distribute the context file to remote hosts successfully Start to health check for the cluster. Total Items:1 Nodes:1 Checking... [=========================] 1/1 Start to analysis the check result CheckClusterState...........................OK The item run on 1 nodes. success: 1 Analysis the check result successfully Success. All check items run completed. Total:1 Success:1 For more information please refer to /home/gbase/gbase_db/om_f5c5a0af/script/gspylib/inspection/output/CheckRepor t_202212063481010006.tar.gz 检查参数 以管理员身份登录数据库,使用show 命令查看指定参数的值。 SHOW parameter_name; 例如,查看listen_addresses 参数值: [gbase@gbase8c ~]$ gsql -d postgres -p 5432 gsql ((multiple_nodes GBase8cV5 3.0.0B52 build 0b9407bc) compiled at 2022-11-18 16:09:02 commit 0 last mr 874 ) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help. postgres=# show listen_addresses; listen_addresses ------------------------ localhost,10.0.7.16 (1 row) 修改参数 通过gs_guc 命令修改参数值。参数修改生效方式不同,请参看《GBase 8c V5_3.0.0 开 发者指南》“重设参数”章节。 gs_guc reload -Z node_type -D datadir -c "paraname_name=value"
GBase 8c 管理员指南 南大通用数据技术股份有限公司 9 例如,修改listen_addresses 参数: [gbase@gbase ~]$ gs_guc reload -Z datanode -D /home/gbase/data/dn1/dn1_1/ -c "listen_addresses='localhost,10.0.7.16,10.0.7.17'" The gs_guc run with the following arguments: [gs_guc -Z datanode -D /home/gbase/data/dn1/dn1_1/ -c listen_addresses='localhost,10.0.7.16,10.0.7.17' reload ]. expected instance path: [/home/gbase/data/dn1/dn1_1/postgresql.conf] gs_guc reload: listen_addresses='localhost,10.0.7.16,10.0.7.17': [/home/gbase/data/dn1/dn1_1/postgresql.conf] server signaled Total instances: 1. Success to perform gs_guc!