Re: PostgreSQL 10 not archiving some WAL files - Mailing list pgsql-general

From Michael Paquier
Subject Re: PostgreSQL 10 not archiving some WAL files
Date
Msg-id 20200319015044.GO214947@paquier.xyz
Whole thread Raw
In response to PostgreSQL 10 not archiving some WAL files  (Norberto Dellê <betodelle@gmail.com>)
Responses Re: PostgreSQL 10 not archiving some WAL files  (Norberto Dellê <betodelle@gmail.com>)
Re: PostgreSQL 10 not archiving some WAL files  (Norberto Dellê <betodelle@gmail.com>)
List pgsql-general
On Wed, Mar 18, 2020 at 10:57:22AM -0300, Norberto Dellê wrote:
> This setup worked very well for a long time, but since we upgraded
> PostgreSQL to newer versions (10.x), sometimes it just skips archiving some
> wal files. This seems to happen mainly when the server is shut down.
> There's no messages about errors in the logs, and also no corresponding
> .done file in archive_status, it just goes to the next wal file.
>
> I would like to know if any of you had or has a problem like this, and if
> you had, how you solved it.

Hmm.  I don't recall seeing any of that.  This would mean that we are
either missing the generation of some .ready file, or that some .done
file gets generated when they should not in archive_status/.  What
kind of server shutdown are you doing?  Immediate so as recovery
happens at the follow-up startup.  Or is that a clean service
shutdown?
--
Michael

Attachment

pgsql-general by date:

Previous
From: Kostya
Date:
Subject: Re: SET LOCAL doesn't become undefined after transaction is commited
Next
From: Peter Krefting
Date:
Subject: RPMs from postgresql.org break CentOS/RHEL RPMs