Hi Andrey,


On Mon, Mar 05, 2018 at 08:51:34AM +0200, Andrey Koblyuk wrote:
> I would like to create a table once a week with a new name (for 
> example,acct_%w%Y), which would store non-historical data from 
> aggregate[storage]                      : 
> src_host,dst_host,src_port,dst_port,proto,src_as,dst_as,in_iface,out_iface
> sql_optimize_clauses[storage]           : true
> sql_table[storage]                      : all_traffic
> sql_table_type[storage]                 : bgp
> sql_dont_try_update[storage]            : true
> sql_use_copy[storage]                   : true
> Will the directives sql_table_schema/sql_table_with_dynamic_name work without 
> sql_history_roundoff/sql_history?

To aggregate flows in the weekly time bin (which i seem to understand is
not what you want, so just mentioning), use the above config including
a definition for sql_history and sql_history_roundoff. To not aggretate
flows (which i seem to understand is what you want), then please add
'timestamp_start, timestamp_end' to your 'aggregate' line. So, in short,
both behaviours are available and can be achieved.


pmacct-discussion mailing list

Reply via email to