Getting AWS RDS Log files

example.md

$ python get_logs.py rds-db-instance-name rds.log aws-access-key aws-secret-key
$ ./pgbadger -p '%t:%r:%u@%d:[%p]:' ./rds.log
$ open out.html

get_logs.py

# -*- encoding: utf-8 -*-
import sys
import boto.rds

AWS_REGION = 'ap-northeast-1'


def get_all_logs(dbinstance_id, output, max_records=None,
                 aws_access_key_id=None, aws_secret_access_key=None):
    conn = boto.rds.connect_to_region(
        AWS_REGION,
        aws_access_key_id=aws_access_key_id,
        aws_secret_access_key=aws_secret_access_key)

    with open(output, 'w') as f:
        for log_file in conn.get_all_logs(dbinstance_id,
                                          max_records=max_records):
            print 'Download %s(%d)' % (log_file.log_filename,
                                       int(log_file.size))
            try:
                log = conn.get_log_file(dbinstance_id, log_file.log_filename)
                try:
                    f.write(log.data)
                except AttributeError:
                    pass
            except:
                print 'Error while download %s' % log_file.log_filename

if __name__ == '__main__':
    get_all_logs(dbinstance_id=sys.argv[1],
                 output=sys.argv[2],
                 aws_access_key_id=sys.argv[3],
                 aws_secret_access_key=sys.argv[4])