template(name="sql-syslog" type="list" option.sql="on") {
  constant(value="INSERT INTO tablename (request_time, server, ip, request) values ('")
  property(name="timereported" dateformat="pgsql")
  constant(value="','")
  property(name="fromhost")
  constant(value="','")
  property(name="msg"
    regex.type="ERE"
    regex.submatch="1"
    regex.expression="([0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}) (.*\.) (.*)$"
    regex.nomatchmode="DFLT"
  )
  constant(value="','")
    property(name="msg"
    regex.type="ERE"
    regex.submatch="2"
    regex.expression="([0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}) (.*\.) (.*)$"
    regex.nomatchmode="DFLT"
    )
  )
  constant(value="')")
}

# load module
module(load="ompgsql")

action(type="ompgsql" server="dbhost"
       user="dbuser" pass="dbpass"
       db="dbname"
       template="sql-syslog"
       queue.size="1000"
       queue.type="LinkedList"
       queue.filename="dbq"
       queue.workerthreads="5"
       queue.workerthreadMinimumMessages="500"
       queue.timeoutWorkerthreadShutdown="1000"
       queue.timeoutEnqueue="10000")