Skip to content

Instantly share code, notes, and snippets.

@dserodio

dserodio/test-psql-connectivity.sh

Last active April 7, 2020 22:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dserodio/2778c346280472b4d63ca5087a4d0b67 to your computer and use it in GitHub Desktop.
Save dserodio/2778c346280472b4d63ca5087a4d0b67 to your computer and use it in GitHub Desktop.
Download ZIP
Useful for testing downtime while applying modifications in RDS
Raw
test-psql-connectivity.sh
while true; do
date -Isec | sed -e 's/+00:00//' | tr '\n' ' '
pg_isready -h YOUR_RDS_INSTANCE.rds.amazonaws.com -U USER -d DB_NAME
sleep 1
done | tee connection-test-$(date -Imin).log
@dserodio
Copy link
Author

dserodio commented Apr 7, 2020

Note: this uses GNU date, macOS date doesn't understand -I

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment