By using AWS re:Post, you agree to the Terms of Use

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.

1 Answers
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

answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions