Skip to content

Instantly share code, notes, and snippets.



Created Sep 24, 2018
What would you like to do?
Config. AWS PostgreSQL RDS to use pgbadger

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
You can’t perform that action at this time.