Skip to content

Instantly share code, notes, and snippets.

@dserodio dserodio/
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.