Paolo, I couldnt get any useful information from this command. I get no erros in postgresql, nfacctd and pmacctd log files.
Data is still being written in DB, but I'm suspecting that some are being lost. Because my database grew just 5G/day after that. Why the process are being accumulated just when my database is about 15G? Is it possible that I'm losing data, even with no errors? Cheers. 2010/5/13 Paolo Lucente <[email protected]> > Hi Sergio, > > It looks those processes are locked out of the table they want to > write to. In MySQL you can check this kind of stuff with a "SHOW > PROCESSLIST"; the PostgreSQL equivalent should be "SELECT * FROM > pg_stat_activity". Its output might very well shed some light. > > Just btw, the number of pmacct processes allowed to queue up is > settable via the sql_max_writers configuration directive. > > Cheers, > Paolo > > > On Thu, May 13, 2010 at 10:04:14AM -0300, Sergio Charpinel Jr. wrote: > > Hi, > > > > After less than one day running pmacct, my database grew from 1.5G to > 15G. > > At this point I get a lot of postmaster and nfacctd process, and none of > > them seems to be using CPU and not writting in DB. > > > > 6774 root 15 0 160m 103m 916 S 0.0 0.9 0:04.04 nfacctd > > 6775 postgres 15 0 2210m 1.3g 1.3g S 0.0 11.8 0:31.50 postmaster > > 6784 root 15 0 160m 103m 916 S 0.0 0.9 0:04.19 nfacctd > > 6785 postgres 16 0 2210m 1.1g 1.1g S 0.0 9.9 0:23.77 postmaster > > 6794 root 15 0 160m 103m 916 S 0.0 0.9 0:02.81 nfacctd > > 6795 postgres 15 0 2210m 1.1g 1.1g S 0.0 9.4 0:20.57 postmaster > > 6804 root 15 0 160m 103m 916 S 0.0 0.9 0:02.04 nfacctd > > 6805 postgres 16 0 2210m 870m 867m S 0.0 7.4 0:14.03 postmaster > > 6819 root 15 0 160m 103m 916 S 0.0 0.9 0:02.64 nfacctd > > 6820 postgres 15 0 2210m 816m 813m S 0.0 7.0 0:13.14 postmaster > > 6829 root 15 0 160m 103m 916 S 0.0 0.9 0:01.17 nfacctd > > 6830 postgres 15 0 2210m 625m 622m S 0.0 5.3 0:09.63 postmaster > > 6861 root 15 0 160m 103m 916 S 0.0 0.9 0:01.28 nfacctd > > 6862 postgres 15 0 2210m 558m 556m S 0.0 4.8 0:08.16 postmaster > > 6889 root 15 0 160m 103m 916 S 0.0 0.9 0:00.33 nfacctd > > 6890 postgres 16 0 2210m 269m 267m D 0.0 2.3 0:03.16 postmaster > > > > [ ... ] > > > _______________________________________________ > pmacct-discussion mailing list > http://www.pmacct.net/#mailinglists > -- Sergio Roberto Charpinel Jr.
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
