Version 9.6.2 Checkpoint on primary server: [ 2017-04-17 17:23:25 BRT] @ LOG: checkpoint complete: wrote 19436 buffers (2.4%); 0 transaction log file(s) added, 2 removed, 7 recycled; write=149.506 s, sync=0.310 s, total=149.958 s; sync files=370, longest=0.012 s, average=0.000 s; distance=133971 kB, estimate=226109 kB
thanks, 2017-04-17 17:24 GMT-03:00 Luciano Mittmann <mittm...@gmail.com>: > Hi Jeff, > > checkpoint message on standby node: > > [ 2017-04-17 17:21:56 BRT] @ LOG: restartpoint complete: wrote 21475 > buffers (2.6%); 0 transaction log file(s) added, 0 removed, 0 recycled; > write=149.816 s, sync=0.064 s, total=149.890 s; sync files=314, > longest=0.002 s, average=0.000 s; distance=145449 kB, estimate=236346 kB > [ 2017-04-17 17:21:56 BRT] @ LOG: recovery restart point at 126/A7072A88 > [ 2017-04-17 17:21:56 BRT] @ DETAIL: last completed transaction was at > log time 2017-04-17 17:21:02.289164-03 > > > > > 2017-04-17 17:08 GMT-03:00 Jeff Janes <jeff.ja...@gmail.com>: > >> On Mon, Apr 17, 2017 at 12:22 PM, Luciano Mittmann <mittm...@gmail.com> >> wrote: >> >>> Hi All, >>> >>> anyone knows why there are so many files in the directory >>> pg_xlog/archive_status/ in replication server? >>> >>> # pg_xlog/archive_status/ | wc -l >>> >>> 75217 >>> >>> Is possible to clean this .done files or just don't need to worry ? >>> >>> It's not occurs on primary or standalone servers, just on replication. >>> >> >> What version? Are you logging checkpoints, and if so what do they say? >> >> Cheers, >> >> Jeff >> > >
