Re: [GENERAL] streaming replication and archive_status - Mailing list pgsql-general

From Luciano Mittmann
Subject Re: [GENERAL] streaming replication and archive_status
Date
Msg-id CAAP4uS4s5+dxh2EdHWzmde_PwyccouiNKdD9hGntBHMEzTv=_Q@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] streaming replication and archive_status  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general


2017-04-18 22:46 GMT-03:00 Jeff Janes <jeff.janes@gmail.com>:
On Tue, Apr 18, 2017 at 5:20 AM, Luciano Mittmann <mittmann@gmail.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,

pgsql-general by date:

Previous
From: Tim Kane
Date:
Subject: Re: [GENERAL] UDP buffer drops / statistics collector
Next
From: Rj Ewing
Date:
Subject: Re: [GENERAL] full text search on hstore or json with materialized view?