Skip to content

Instantly share code, notes, and snippets.

@HieronyM
Last active April 16, 2019 08:21
Show Gist options
  • Select an option

  • Save HieronyM/422723cc2d9eaa00c23f63eb186e9723 to your computer and use it in GitHub Desktop.

Select an option

Save HieronyM/422723cc2d9eaa00c23f63eb186e9723 to your computer and use it in GitHub Desktop.
List Postgres RDS to be upgraded
policies:
- name: list_specific-postgres-rds
resource: rds
filters:
- type: value
key: "Engine"
op: equal
value: postgres
- type: value
key: "EngineVersion"
op: not-in
value: ['9.4.20', '9.5.15', '9.6.11', '10.6']
description: |
List all RDS Postgres instance that not version 9.4.20, 9.5.15, 9.6.11, and 10.6
Run command..
custodian run -s output \
-r all \
--cache-period 0 \
-p list_specific-postgres-rds \
-d \
rds/rds-postgres-specific-version.yml
Report command..
custodian report -s output \
-r all \
-p list_specific-postgres-rds \
--no-default-fields \
--field "DBInstanceIdentifier=DBInstanceIdentifier" \
--field Region=region \
--field "EngineVersion=EngineVersion" \
--field "MultiAZ=MultiAZ" \
--field "ProductDomain=tag:ProductDomain" \
--field "PendingUpdate=PendingModifiedValues" \
--field "AllocatedStorage=AllocatedStorage" \
--field "MaintenanceWindowTime=PreferredMaintenanceWindow" \
rds/rds-postgres-specific-version.yml > csv/rds-postgres-specific-version.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment