En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation

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 réponse
1
Réponse acceptée

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
EXPERT
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions