2017-04-18 22:46 GMT-03:00 Jeff Janes :
> On Tue, Apr 18, 2017 at 5:20 AM, Luciano Mittmann
> wrote:
>
>>
>>
>> Hi Jeff,
>>
>> **Does each file in pg_xlog/archive_status/ have a corresponding file
>> one directory up?
>>
>> no corresponding file on pg_xlog directory. That is the question.. for
>>
On Tue, Apr 18, 2017 at 5:20 AM, Luciano Mittmann
wrote:
>
>
> Hi Jeff,
>
> **Does each file in pg_xlog/archive_status/ have a corresponding file one
> directory up?
>
> no corresponding file on pg_xlog directory. That is the question.. for
> some reason or some parameter that I do not know, the
2017-04-17 20:04 GMT-03:00 Jeff Janes :
> 2017-04-17 17:08 GMT-03:00 Jeff Janes :
>
>> On Mon, Apr 17, 2017 at 12:22 PM, Luciano Mittmann
>> wrote:
>>
>>> Hi All,
>>>
>>> anyone knows why there are so many files in the directory
>>> pg_xlog/archive_status/ in replication server?
>>>
>>> # pg_xlog
2017-04-17 17:08 GMT-03:00 Jeff Janes :
> On Mon, Apr 17, 2017 at 12:22 PM, Luciano Mittmann
> 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 possib
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
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=145
On Mon, Apr 17, 2017 at 12:22 PM, Luciano Mittmann
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
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.
T
