Re: Critical failure of standby

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Critical failure of standby
Дата
Msg-id CAMkU=1y0Le5QpZUq8A-Xh-sc5kLYoSZfFWz8aX-KVn3C0DEBCA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Critical failure of standby  (James Sewell <james.sewell@jirotech.com>)
Список pgsql-general
On Mon, Aug 15, 2016 at 7:23 PM, James Sewell <james.sewell@jirotech.com> wrote:
Those are all good questions.

Essentially this is a situation where DR is network separated from Prod - so I would expect the archive command to fail.


archive_command or restore_command?  I thought it was restore_command.

 
I'll have to check the script it must not be passing the error back through to PostgreSQL.

This still shouldn't cause database corruption though right? - it's just not getting WALs.

If the WAL it does have is corrupt, and it can't replace that with a good copy because the command is failing, then what else is it going to do?

If the original WAL transfer got interrupted mid-stream, then you will have a bad record in the middle of the WAL.  If by some spectacular stroke of bad luck, the CRC checksum on that bad record happens to collide, then it will try to decode that bad record.

Cheers,

Jeff

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: endash not a graphic character?
Следующее
От: rob stone
Дата:
Сообщение: Re: endash not a graphic character?