Skip to content

Latest commit

 

History

History

postgres

README.md

Posgres storage plugin

Plugin description

Plugin stores IPFIX data into PostgreSQL database so it need postgresql library installed. Recommended PostgreSQL version is at least 8.4.9.

Configuration

Default plugin configuration in internalcfg.xml:

<storagePlugin>
	<fileFormat>postgres</fileFormat>
	<file>/usr/share/ipfixcol/plugins/ipfixcol-postgres-output.so</file>
	<threadName>postgres</threadName>
</storagePlugin>

Or as ipfixconf output:

     Plugin type         Name/Format     Process/Thread         File        
 ----------------------------------------------------------------------------
        storage             postgres            postgres         /usr/share/ipfixcol/plugins/ipfixcol-postgres-output.so

Plugin needs configured information about database connection and user.

Example startup.xml configuration:

 <destination>
     <name>store data records in PostgreSQL database</name>
     <fileWriter>
          <fileFormat>postgres</fileFormat>
          <host>localhost</host>
          <hostaddr>localhost</hostaddr>
          <port>5432</port>
          <dbname>test</dbname>
          <user>username</user>
          <pass>password</pass>
     </fileWriter>
</destination>
  • host is name of host to connect to
  • hostaddr is IP address of host
  • port to connect to
  • dbname is name of database
  • user is name to use for connection
  • pass is password for authentication

Back to Top