Re: streaming replication and archive_status

From: Luciano Mittmann <mittmann(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: streaming replication and archive_status
Date: 2017-04-19 18:40:52
Message-ID: CAAP4uS4s5+dxh2EdHWzmde_PwyccouiNKdD9hGntBHMEzTv=_Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2017-04-18 22:46 GMT-03:00 Jeff Janes <jeff(dot)janes(at)gmail(dot)com>:

> On Tue, Apr 18, 2017 at 5:20 AM, Luciano Mittmann <mittmann(at)gmail(dot)com>
> 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 files are
>> considered consumed but are not erased later.
>>
>
> I can see how a well-timed crash could leave behind a few .done files, but
> not 75 thousand of them.
>
> Are they still accumulating, or was it only an historical accumulation?
>
> Also, is this on Windows?
>
> Cheers,
>
> Jeff
>

Hey Jeff,

they are still accumulating, 78k today.
Running on SLES 12.1

regards,

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rj Ewing 2017-04-19 18:57:26 Re: full text search on hstore or json with materialized view?
Previous Message Tim Kane 2017-04-19 18:36:20 Re: UDP buffer drops / statistics collector