Re: streaming replication and archive_status

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Luciano Mittmann <mittmann(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: streaming replication and archive_status
Date: 2017-04-19 01:46:32
Message-ID: CAMkU=1zZbqbavMFgMQuJ4k2ejJAZg+OLyNRhokTxm1nAPzwsYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Samuel Williams 2017-04-19 04:01:40 Large data and slow queries
Previous Message Sar 2017-04-18 23:59:59 Experiencing "compressed data is corrupted" error