Public | Automated Build

Last pushed: a year ago
Short Description
Download RDS logs and generate pgbadger report.
Full Description

RDS PgBadger

A tool to easily download logs from an AWS RDS instance and generate pgBadger reports.


pgBadger must be installed. Download and install from the site or on OSX run brew install pgbadger.

Setup your AWS credentials in your ~/.fog file. Example:

  aws_access_key_id: tacos
  aws_secret_access_key: foobar
  aws_access_key_id: cats
  aws_secret_access_key: foobaz

If you do not have a fog file, the AWS SDK will try to use its regular credential resolving methods.


Execute the Ruby script proving the target environment and RDS instance identifier.

./rds-pgbadger.rb -e env1 -i my-rds-instance

It will download the log files and generate a report in the out folder named after the instance id and a timestamp of when the script executed.

You can additionally filter the retrieved log files by date:

./rds-pgbadger.rb -e env1 -i my-rds-instance -d 2015-01-13



docker build -t user/rds-pgbadger .

Run locally

docker run --rm -it -v ~/.fog:/root/.fog -v pwd/out:/app/out creack/rds-pgbadger -i leaf -d 2016-04-23-01

Run on EC2

docker run --rm -it -v pwd/out:/app/out creack/rds-pgbadger -i <dbname> -d <yyyy>-<mm>-<dd>[-<hh>]


rds-pgbadger tried to open the generated html once done. Within docker this will fail so the following error is expected and you will have to manually open the html file.

/app/rds-pgbadger.rb:49:in ``': No such file or directory - open (Errno::ENOENT)
from /app/rds-pgbadger.rb:49:in `<main>'
Docker Pull Command
Source Repository