Hi, I'm using pmacct-0.12.0rc3 with postgresql.
I've been trying to work out what pmpgplay does when it looks at a log file. I couldn't find much in my searches that go into the details of how it does things.
It seems it generates a bunch of sql, but does it check to see if that record exists already before applying the change?
I'm worried about replaying the log and it double-recording data (ie the data is already recorded in the db, and then replaying the log does it again), or will it only apply new records that it can't find in the db?
I have a missing chunk of data from my database (about 1.5 hrs worth) that I can see in the logs, but the log is surrounded by data that could be in the database (I haven't checked each individual log entry).
Relevant pmacct.conf info: plugin_pipe_size:1024000 plugin_buffer_size:8192 imt_buckets: 65537 imt_mem_pools_size: 1024000 sql_table_version:1 sql_refresh_time: 60 sql_history: 5m Any information is much appreciated, thanks! -- Postgresql & php tutorials http://www.designmagick.com/ _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
