Re: During promotion, new master tries to archive same segment twice

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: During promotion, new master tries to archive same segment twice
Дата
Msg-id b0979e77-fe08-091d-cdd8-43eaece422d2@aklaver.com
обсуждение исходный текст
Ответ на Re: During promotion, new master tries to archive same segmenttwice  ("Phil Endecott" <spam_from_pgsql_lists@chezphil.org>)
Ответы Re: During promotion, new master tries to archive same segmenttwice  ("Phil Endecott" <spam_from_pgsql_lists@chezphil.org>)
Список pgsql-general
On 08/16/2018 01:48 AM, Phil Endecott wrote:
> Adrian Klaver wrote:
>> On 08/15/2018 01:25 PM, Phil Endecott wrote:
>>> Dear Experts,
>>>

>> The above is not clear to me. My best guess:
>>

> It's not part of the error for the archive command; it's just the
> next thing in the log file.  Y is (1) trying write WAL segment
> E8 to the Y-to-Z archive and failing because it is already there and
> (2) trying to read WAL segment E9 from the X-to-Y archive and failing
> because it doesn't exist (and never will).  (1) is the problem, (2) is
> expected.

Hmm, still not sure why they are both showing up in the same LOG: entry 
as the entry was for the failure of the archive_command.

What is archive_mode set to on Y?


-- 
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: Vikas Sharma
Дата:
Сообщение: Copy over large data Postgresql 9.5
Следующее
От: Tom Lane
Дата:
Сообщение: Re: regex match and special characters