pg Gem Load Error about fluent-plugin-sql HOT 3 CLOSED

The version of pg gem was incorrect.

from fluent-plugin-sql.

@anuragensemble
So which one is correct? Have same issue.

pg v0.21.0 not working:

2018-07-11 15:18:25 +0000 [info]: starting fluentd-1.2.2 pid=6 ruby="2.4.4"

2018-07-11 15:18:25 +0000 [info]: spawn command to main: cmdline=["/usr/bin/ruby", "-Eascii-8bit:ascii-8bit", "/usr/bin/fluentd", "-c", "/fluentd/etc/fluent.conf", "-p", "/fluentd/plugins", "--under-supervisor"]

2018-07-11 15:18:26 +0000 [info]: gem 'fluent-plugin-sql' version '1.0.0'

2018-07-11 15:18:26 +0000 [info]: gem 'fluentd' version '1.2.2'

2018-07-11 15:18:26 +0000 [info]: adding match pattern="nginx.access.log" type="sql"

2018-07-11 15:18:26 +0000 [info]: #0 'flush_interval' is configured at out side of . 'flush_mode' is set to 'interval' to keep existing behaviour

2018-07-11 15:18:26 +0000 [warn]: #0 'type' is deprecated parameter name. use '@type' instead.

2018-07-11 15:18:26 +0000 [info]: adding source type="tail"

2018-07-11 15:18:26 +0000 [info]: #0 starting fluentd worker pid=16 ppid=6 worker=0

2018-07-11 15:18:26 +0000 [error]: #0 unexpected error error_class=LoadError error="Could not load 'active_record/connection_adapters/postgresql_adapter'. Make sure that the adapter in config/database.yml is valid. If you use an adapter other than 'mysql', 'mysql2', 'postgresql' or 'sqlite3' add the necessary adapter gem to the Gemfile."

from fluent-plugin-sql.

Found solution here #47

from fluent-plugin-sql.