DdengxuyueMisc bugfixes
3d79c591创建于 2021年3月6日历史提交
--
-- TEST CASE: support the parameters with same name in postgrsql.conf
--

--show previous value of the parameter
show autovacuum_naptime;
show enable_resource_track;
show memorypool_size;

--append to the end of postgrsql.conf
\! echo 'autovacuum_naptime = 2min' >> @abs_srcdir@/tmp_check/datanode1/postgresql.conf
\! echo 'autovacuum_naptime = 5min' >> @abs_srcdir@/tmp_check/datanode1/postgresql.conf
\! echo 'autovacuum_naptime = 4min' >> @abs_srcdir@/tmp_check/datanode1/postgresql.conf
\! echo 'enable_resource_track = off' >> @abs_srcdir@/tmp_check/datanode1/postgresql.conf
\! echo 'enable_resource_track = on' >> @abs_srcdir@/tmp_check/datanode1/postgresql.conf
\! echo 'memorypool_size = 500MB' >> @abs_srcdir@/tmp_check/datanode1/postgresql.conf
\! echo 'memorypool_size = 600MB' >> @abs_srcdir@/tmp_check/datanode1/postgresql.conf


--reset value of the parameter
alter system set autovacuum_naptime to '3min';

alter system set enable_resource_track to 'off';

alter system set memorypool_size to '550MB';

--show new value of the parameter
show autovacuum_naptime;
show enable_resource_track;

--restart database
\! @abs_bindir@/gs_ctl restart -D @abs_srcdir@/tmp_check/datanode1/ > /dev/null 2>&1
--show new value of the parameter with postmaster level
\! @abs_bindir@/gsql -d postgres -p @portstring@ -c 'show memorypool_size'