Skip to content

Instantly share code, notes, and snippets.

@dserodio

dserodio/README.md

Created September 24, 2018 21:06
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/ece56804518e27f94559bb4c31b75dc3 to your computer and use it in GitHub Desktop.
Save dserodio/ece56804518e27f94559bb4c31b75dc3 to your computer and use it in GitHub Desktop.
Download ZIP
Config. AWS PostgreSQL RDS to use pgbadger
Raw
README.md

Set the following properties in RDS:

log_min_duration_statement = 250
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_temp_files = 0
log_autovacuum_min_duration = 0
log_error_verbosity = default

Run pgbadger like this:

$ pgbadger -p '%t:%r:%u@%d:[%p]:' postgres.log
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment