Re: PostgreSQL 10 not archiving some WAL files

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: PostgreSQL 10 not archiving some WAL files
Дата
Msg-id 20200319015044.GO214947@paquier.xyz
обсуждение исходный текст
Ответ на PostgreSQL 10 not archiving some WAL files  (Norberto Dellê <betodelle@gmail.com>)
Ответы Re: PostgreSQL 10 not archiving some WAL files
Re: PostgreSQL 10 not archiving some WAL files
Список 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

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Kostya
Дата:
Сообщение: Re: SET LOCAL doesn't become undefined after transaction is commited
Следующее
От: Peter Krefting
Дата:
Сообщение: RPMs from postgresql.org break CentOS/RHEL RPMs