PostGRESQL
The PostGRES output module allows you to write data to a PostGRESQL database server.
Parameter | Default | Meaning |
---|---|---|
host | localhost | The host name or IP address of the server |
user | The name of the database user | |
password | The database password | |
database | The name of the database | |
sql | INSERT INTO events (start,end,message) VALUES ('%S','%E','%M') | The sql statement to execute, including event codes |
timezone | UTC | The 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.