# gs_disk_threshold

**Repository Path**: smalldba/gs_disk_threshold

## Basic Information

- **Project Name**: gs_disk_threshold
- **Description**: 主要是解决opengauss,因为cm_server参数datastorage_threshold_value_check无效问题，原因是长连接导致，目前我的程序是解决到达指定阈值后pg_terminate_backend这些线程让它重新连接，然后就可以生效了。之后是自保了，这是运维人最后的倔强了
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-08-28
- **Last Updated**: 2025-08-28

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

rm -rf CMakeCache.txt CMakeFiles cmake_install.cmake Makefile


nlohmann

gsql -U opengauss  -p 7654 -d postgres -r
/opt/ulility_private/gs_disk_threshold/src

gsql -U smalldb -W 'huawei@123456' -h 127.0.0.1 -p 7654 -d smalldb -r

(smalldb@127.0.0.1:7654) [smalldb] > select pg_backend_pid();
 pg_backend_pid
-----------------
 139981045626560
(1 row)

(smalldb@127.0.0.1:7654) [smalldb] > select pg_sleep(1000);





To run a command as administrator(user "root"),use "sudo <command>".
[opengauss@gaussdb ~]$  gsql -U smalldb -W 'huawei@123456' -h 127.0.0.1 -p 7654 -d smalldb -r
gsql ((openGauss 6.0.0 build ) compiled at 2024-12-19 00:17:38 commit 0 last mr  release)
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

(smalldb@127.0.0.1:7654) [smalldb] >  select pg_backend_pid();
 pg_backend_pid
-----------------
 139981045626560
(1 row)

(smalldb@127.0.0.1:7654) [smalldb] > select pg_sleep(1000);
FATAL:  terminating connection due to administrator command
CONTEXT:  referenced column: pg_sleep
FATAL:  terminating connection due to administrator command
CONTEXT:  referenced column: pg_sleep
The connection to the server was lost. Attempting reset: Failed.
(@:?) [] > gs