Hi Andrey, Inline:
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. Paolo _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists