Contents

# Fluent::Plugin::PgJson

Output Plugin for PostgreSQL Json Type.

<b>Json type is availble in PostgreSQL version over 9.2</b>

## Installation

`$ fluent-gem install fluent-plugin-pgjson`

## Schema

Specified table must have this schema.

|col|type|
|---|---|
|{tag_col}|Text|
|{time_col}|Timestamp WITH TIME ZONE|
|{record_col}|Json|

### Example

```
CREATE TABLE fluentd (
    tag Text
    ,time Timestamptz
    ,record Json
);
```

## Configuration

### Example

```
<match **>
  type pgjson
  host localhost
  port 5432
  sslmode require
  database fluentd
  table fluentd
  user postgres
  password postgres
  time_col time
  tag_col tag
  record_col record
</match>
```

### Parameter

|parameter|description|default|
|---|---|---|
|host|postgres server hostname|localhost|
|port|postgres server port number|5432|
|sslmode|use ssl (disable/allow/prefer/require)|prefer||
|database|database name to which records will be inserted||
|table|table name to which records will be inserted||
|user|user name used to connect database|nil|
|password|password uset to connect database|nil|
|time_col|column name to insert time|time|
|tag_col|column name to insert tag|tag|
|record_col|column name to insert record|record|

## Copyright

<table>
<tr><td>Copyright</td><td>Copyright (c) 2012,2013 OKUNO Akihiro</td></tr>
<tr><td>License</td><td>Apache License, Version 4.0</td></tr>
</table>

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
fluent-plugin-pgjson-0.0.4	README.md