aws rds cli -- need to search the db-parameter-group(s) for a specific parameter

0

Hello all. I am successful at querying "aws --no-verify-ssl rds describe-db-parameter-groups". But, I'm trying to filter down in order to view one parameter (audit_trail). Secondly, I need to modify the parameter value to a new string. All I'm finding in the documentation, however, looks like "-> (file)". IOW search the parameter groups for the string "oracle", then the parameters for the string "audit_trail", then the parameterVaule for the string "os". Your guidance is appreciated.

已提問 2 年前檢視次數 1799 次
1 個回答
1
已接受的答案

Hello,

Thanks for posting to AWS re:Post. Viewing of these parameters can be done by describe-db-parameters https://docs.aws.amazon.com/cli/latest/reference/rds/describe-db-parameters.html

Example aws rds describe-db-parameters --db-parameter-group-name xxxx --query 'Parameters[].{ParameterName: ParameterName, ParameterValue: ParameterValue}' --output json https://docs.aws.amazon.com/cli/latest/userguide/cli-usage-filter.html

You can also output to a file ">filename.txt" at the end

Modify by aws rds modify-db-parameter-group --db-parameter-group-name xxxx --parameters "ParameterName='xxxx',ParameterValue=xxxx,ApplyMethod=immediate" https://docs.aws.amazon.com/cli/latest/reference/rds/modify-db-parameter-group.html

AWS
專家
已回答 2 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南