I created a new policy in the 23.8 version directory /etc/clickhouse-server/config.d as follows:
The log also shows that zxlpolicy1 is loaded.
You can also check the system table storage_policies.
Question:
Based on the above, I delete zxlpolicy1 and create a new zxlpolicy2. The service log shows that zxlpolicy2 is loaded, but there is no zxlpolicy2 in system.storage_policies.
clickhouse-server log:
system.storage_policies：
I have to restart the cluster system table to load zxlpolicy2.
How can I get the system tables to load into zxlpolicy2 without restarting the cluster?
Env :
I created a new policy in the 23.8 version directory /etc/clickhouse-server/config.d as follows:
The log also shows that zxlpolicy1 is loaded.
You can also check the system table storage_policies.
Question:
Based on the above, I delete zxlpolicy1 and create a new zxlpolicy2. The service log shows that zxlpolicy2 is loaded, but there is no zxlpolicy2 in system.storage_policies.
clickhouse-server log:
system.storage_policies：
I have to restart the cluster system table to load zxlpolicy2.
How can I get the system tables to load into zxlpolicy2 without restarting the cluster?