PostGRESQL

The PostGRES output module allows you to write data to a PostGRESQL database server.

ParameterDefaultMeaning
hostlocalhostThe host name or IP address of the server
userThe name of the database user
passwordThe database password
databaseThe name of the database
sqlINSERT INTO events (start,end,message) VALUES ('%S','%E','%M')The sql statement to execute, including event codes
timezoneUTCThe timezone to write date data in.

Example (Event)

[
   {
       "type": "event",
       "method": "mysql",
       "host": "myserver",
       "user": "myuser",   
       "password": "mypass",
       "database": "eventlog",
       "sql": "INSERT INTO events (start,end,message) VALUES ('%S','%E','%M')",
       "timezone": "Australia/Sydney"
   }
]

Other Modules

Return to the list of output modules.