Postgres Pro
Downloads
Home   >   mailing lists

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

From Norberto Dellê
Subject PostgreSQL 10 not archiving some WAL files
Date
Msg-id CAC_JJAumfPdk0miBO5y3x-ieHgT61jH2Ah1q8MPmY2KJO8NVHw@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL 10 not archiving some WAL files
List pgsql-general
Tree view

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.

pgsql-general by date:

Previous
From: Kostya
Date:
Subject: SET LOCAL doesn't become undefined after transaction is commited
Next
From: Tom Lane
Date:
Subject: Re: SET LOCAL doesn't become undefined after transaction is commited