PostgreSQL 10 not archiving some WAL files

From: Norberto Dellê <betodelle(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL 10 not archiving some WAL files
Date: 2020-03-18 13:57:22
Message-ID: CAC_JJAumfPdk0miBO5y3x-ieHgT61jH2Ah1q8MPmY2KJO8NVHw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I have a strange case in some PostgreSQL instances that I monitor. First
the software versions and setup of a specific one:

- Windows Server 2012 Foundation
- PostgreSQL 10.10 x64
- archive_command = 'copy% p "D: \\ backup \\ wal \\% f" / y'

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-03-18 14:16:23 Re: SET LOCAL <var> doesn't become undefined after transaction is commited
Previous Message Kostya 2020-03-18 11:22:20 SET LOCAL <var> doesn't become undefined after transaction is commited