I am trying to setup rds postgres monitoring with pmm docker contaner. As part of setup , I created aws user plus following user policy plus separate db user with necessary permissions.
{
“Version”: “2012-10-17”,
“Statement”: [{
“Sid”: “Stmt1508404837003”,
“Effect”: “Allow”,
“Action”: [
“rds:DescribeDBInstances”,
“cloudwatch:GetMetricStatistics”,
“cloudwatch:ListMetrics”
],
“Resource”: [""]
},
{
“Sid”: “Stmt1508410723001”,
“Effect”: “Allow”,
“Action”: [
“logs:DescribeLogStreams”,
“logs:GetLogEvents”,
“logs:FilterLogEvents”
],
“Resource”: ["arn:aws:logs:::log-group:RDSOSMetrics:"]
}
]
}
CREATE USER pmm_user with ENCRYPTED PASSWORD ‘xxxxzzzzzyyyy’;
grant rds_superuser to pmm_user;
Finally when I try to add rds postgres database using PMM GUI -> Add Remote Postgresql Instance, I run into following error
[LEFT][COLOR=#D8D9DA]
Any comments /suggestions ?