Skip to content

Instantly share code, notes, and snippets.

@tfentonz

tfentonz/aws_postgres_db_instances.sh

Last active December 6, 2016 00:58
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tfentonz/736f5a09cd62efffcd80a62d47841216 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tfentonz/736f5a09cd62efffcd80a62d47841216 to your computer and use it in GitHub Desktop.
Download ZIP
Ouput array of DB instances with PostgreSQL engine
Raw
aws_postgres_db_instances.sh
#!/bin/bash
aws rds describe-db-instances --query 'DBInstances[].{DBName:DBName,Engine:Engine,EngineVersion:EngineVersion}' |
jq '[.[] | select(.Engine == "postgres") | {db_name:.DBName,engine:.Engine,engine_version:.EngineVersion}]'
exit 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment