[pmacct-discussion] Nfacctd message after adding another NF source

2016-04-28 Thread Anthony Rodriguez 
After adding another NetFlow source we came across a warning as follows 
below. What exactly does this mean?


nfacctd[19879]: WARN ( default/pgsql ): purging process (CAUSE: safe action)

Thanks,
Anthony

--
Anthony Rodriguez
Software Engineer I
NetWolves
Email: anthony.rodrig...@netwolves.com
www.netwolves.com


___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

Re: [pmacct-discussion] Capturing NetFlow in PostgresSQL Database

2016-04-28 Thread Matthew Walster 
On 27 April 2016 at 20:42, Anthony Rodriguez <
anthony.rodrig...@netwolves.com> wrote:

> Hi,
>
> I have set up a test capturing NF into a postgresql 8.4 DB. It seems to
> work OK but the writing to the DB seems
> to get far behind. I had one writer take 1.5 hours to sync. Any hints
> would be appreciated.
>
> Apr 27 10:30:01  nfacctd[31907]: INFO ( default/pgsql ): *** Purging cache
> - START (PID: 31907) ***
> Apr 27 12:59:39  nfacctd[31907]: INFO ( default/pgsql ): *** Purging cache
> - END (PID: 31907, QN: 12482/32819, ET: 8978) ***
>
>
​Have you considered moving to INSERTs rather than UPDATEs?​

​Config key is "
sql_dont_try_update
​"

M​
​
___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists