调用 DescribeDBEngineVersionParameters 接口查询指定数据库引擎版本支持用户设置的参数列表。
同步请求。
参数 | 类型 | 是否必选 | 示例值 | 描述 |
|---|---|---|---|---|
DBEngine | String | 是 | PostgreSQL | 参数模板的类型。当前取值仅能为 PostgreSQL。 |
DBEngineVersion | String | 是 | PostgreSQL_12 | 兼容版本。取值：
|
参数 | 类型 | 示例值 | 描述 |
|---|---|---|---|
DBEngineVersion | String | PostgreSQL_12 | 兼容版本。取值：
|
ParameterCount | String | 39 | 指定数据库引擎版本下支持用户设置的参数个数。 |
Parameters | Object[] | 请参见返回示例。 | 指定数据库引擎版本下支持用户设置的参数列表。 |
POST /?Action=DescribeDBEngineVersionParameters&Version=2022-01-01 HTTP/1.1 Content-Type: application/json Host: rds-postgresql.cn-beijing.volcengineapi.com X-Date: 20231002T101010Z Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20211202/cn-beijing/rds_postgresql/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c6458**** { "DBEngine": "PostgreSQL", "DBEngineVersion": "PostgreSQL_12" }
{ "ResponseMetadata": { "RequestId": "202505072036447244830F171F1504218C-550acb", "Action": "DescribeDBEngineVersionParameters", "Version": "2022-01-01", "Service": "rds_postgresql", "Region": "cn-beijing" }, "Result": { "DBEngineVersion": "PostgreSQL_12", "ParameterCount": "39", "Parameters": [ { "CheckingCode": "[on|off]", "DefaultValue": "off", "ForceRestart": false, "Name": "auto_explain.log_analyze", "Type": "bool" }, { "CheckingCode": "[on|off]", "DefaultValue": "off", "ForceRestart": false, "Name": "auto_explain.log_buffers", "Type": "bool" }, { "CheckingCode": "[text|xml|json|yaml]", "DefaultValue": "text", "ForceRestart": false, "Name": "auto_explain.log_format", "Type": "enum" }, { "CheckingCode": "[-1-60000]", "DefaultValue": "-1", "ForceRestart": false, "Name": "auto_explain.log_min_duration", "Type": "integer" }, { "CheckingCode": "[on|off]", "DefaultValue": "off", "ForceRestart": false, "Name": "auto_explain.log_nested_statements", "Type": "bool" }, { "CheckingCode": "[on|off]", "DefaultValue": "on", "ForceRestart": false, "Name": "auto_explain.log_timing", "Type": "bool" }, { "CheckingCode": "[on|off]", "DefaultValue": "off", "ForceRestart": false, "Name": "auto_explain.log_triggers", "Type": "bool" }, { "CheckingCode": "[on|off]", "DefaultValue": "off", "ForceRestart": false, "Name": "auto_explain.log_verbose", "Type": "bool" }, { "CheckingCode": "[0-1]", "DefaultValue": "1", "ForceRestart": false, "Name": "auto_explain.sample_rate", "Type": "real" }, { "CheckingCode": "[0-50]", "DefaultValue": "2", "ForceRestart": false, "Name": "autovacuum_vacuum_cost_delay", "Type": "real" }, { "CheckingCode": "[on|off]", "DefaultValue": "on", "ForceRestart": true, "Name": "cron.log_run", "Type": "bool" }, { "CheckingCode": "[on|off]", "DefaultValue": "off", "ForceRestart": false, "Name": "default_transaction_deferrable", "Type": "bool" }, { "CheckingCode": "[on|off]", "DefaultValue": "on", "ForceRestart": false, "Name": "enable_partitionwise_aggregate", "Type": "bool" }, { "CheckingCode": "[on|off]", "DefaultValue": "on", "ForceRestart": false, "Name": "enable_partitionwise_join", "Type": "bool" }, { "CheckingCode": "[3000-36000000]", "DefaultValue": "3600000", "ForceRestart": false, "Name": "idle_in_transaction_session_timeout", "Type": "integer" }, { "CheckingCode": "[C|C.UTF-8|en_US.utf8|POSIX|zh_CN.utf8]", "DefaultValue": "C", "ForceRestart": false, "Name": "lc_monetary", "Type": "string" }, { "CheckingCode": "[0-36000000]", "DefaultValue": "0", "ForceRestart": false, "Name": "lock_timeout", "Type": "integer" }, { "CheckingCode": "[-1-2147483647]", "DefaultValue": "10000", "ForceRestart": false, "Name": "log_autovacuum_min_duration", "Type": "integer" }, { "CheckingCode": "[on|off]", "DefaultValue": "off", "ForceRestart": false, "Name": "log_connections", "Type": "bool" }, { "CheckingCode": "[on|off]", "DefaultValue": "off", "ForceRestart": false, "Name": "log_disconnections", "Type": "bool" }, { "CheckingCode": "[-1-600000]", "DefaultValue": "1000", "ForceRestart": false, "Name": "log_min_duration_statement", "Type": "integer" }, { "CheckingCode": "[ddl|mod|all]", "DefaultValue": "ddl", "ForceRestart": false, "Name": "log_statement", "Type": "enum" }, { "CheckingCode": "[4096-1048576]", "DefaultValue": "131072", "ForceRestart": false, "Name": "log_temp_files", "Type": "integer" }, { "CheckingCode": "[-1-2147483647]", "DefaultValue": "300000", "ForceRestart": false, "Name": "max_standby_archive_delay", "Type": "integer" }, { "CheckingCode": "[-1-2147483647]", "DefaultValue": "300000", "ForceRestart": false, "Name": "max_standby_streaming_delay", "Type": "integer" }, { "CheckingCode": "[on|off]", "DefaultValue": "on", "ForceRestart": false, "Name": "pgaudit.log_catalog", "Type": "bool" }, { "CheckingCode": "[debug5|debug4|debug3|debug2|debug1|info|notice|warning|log]", "DefaultValue": "log", "ForceRestart": false, "Name": "pgaudit.log_level", "Type": "string" }, { "CheckingCode": "[on|off]", "DefaultValue": "off", "ForceRestart": false, "Name": "pgaudit.log_parameter", "Type": "bool" }, { "CheckingCode": "[on|off]", "DefaultValue": "off", "ForceRestart": false, "Name": "pgaudit.log_relation", "Type": "bool" }, { "CheckingCode": "[on|off]", "DefaultValue": "off", "ForceRestart": false, "Name": "pgaudit.log_statement_once", "Type": "bool" }, { "CheckingCode": "[*]", "DefaultValue": "", "ForceRestart": false, "Name": "pgaudit.role", "Type": "string" }, { "CheckingCode": "[*auth_delay|pg_stat_statements|auto_explain|pgaudit|pgnodemx|pg_pathman|timescaledb|pg_stat_kcache|pg_hugepage_stat|pg_cron|pg_jieba|pg_hint_plan|pg_bigm]", "DefaultValue": "auth_delay,pg_stat_statements,auto_explain,pgaudit,pgnodemx", "ForceRestart": true, "Name": "shared_preload_libraries", "Type": "string" }, { "CheckingCode": "[0-86400000]", "DefaultValue": "0", "ForceRestart": false, "Name": "statement_timeout", "Type": "integer" }, { "CheckingCode": "[-1-2147483647]", "DefaultValue": "-1", "ForceRestart": false, "Name": "temp_file_limit", "Type": "integer" }, { "CheckingCode": "[*]", "DefaultValue": "Asia/Shanghai", "ForceRestart": false, "Name": "timezone", "Type": "string" }, { "CheckingCode": "[on|off]", "DefaultValue": "off", "ForceRestart": true, "Name": "track_commit_timestamp", "Type": "bool" }, { "CheckingCode": "[0-1000000]", "DefaultValue": "0", "ForceRestart": false, "Name": "vacuum_defer_cleanup_age", "Type": "integer" }, { "CheckingCode": "[on|off]", "DefaultValue": "off", "ForceRestart": false, "Name": "wal_compression", "Type": "bool" }, { "CheckingCode": "[replica|logical]", "DefaultValue": "replica", "ForceRestart": true, "Name": "wal_level", "Type": "enum" } ] } }