Amazon RDS for PostgreSQL log input plugin for fluentd
Overview
- Amazon Web Services RDS log input plugin for fluentd
Installation
$ fluentd-gem install fluent-plugin-rds-pgsql-log
AWS ELB Settings
- settings see: PostgreSQL Database Log Files
When SSL certification error
log:
SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed
Do env setting follows:
SSL_CERT_FILE=/etc/ssl/certs/ca-bundle.crt (If you using amazon linux)
Configuration
<source>
type rds_pgsql_log
# required
region <region name>
db_instance_identifier <instance identifier>
# optional if you can IAM credentials
access_key_id <access_key>
secret_access_key <secret_access_key>
# optional
refresh_interval <interval number by second(default: 30)>
tag <tag name(default: rds-pgsql.log>
pos_file <log getting position file(default: rds-pgsql.log)>
</source>
Example setting
<source>
type rds_pgsql_log
region ap-northeast-1
db_instance_identifier test-postgres
access_key_id XXXXXXXXXXXXXXXXXXXX
secret_access_key xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
refresh_interval 30
tag pgsql.log
pos_file /tmp/pgsql-log-pos.dat
</source>
<match pgsql.log>
type stdout
</match>
json output example
{"time":"2015-05-30 02:19:22 UTC",
"host":"192.168.30.175(53092)",
"user":"testuser",
"database":"db1",
"pid":"9769",
"message_level":"LOG",
"message":" statement: select 1;",
"log_file_name":"error/postgresql.log.2015-05-30-02"
}
Changes
0.2.0
- require fluentd version 0.14.0
0.3.0
- use AWS SDK v3.x
0.4.0
- Use record time