Durability?

Поиск
Список
Период
Сортировка
От Emmanuel Cecchet
Тема Durability?
Дата
Msg-id 4A7C8116.9080707@frogthinker.org
обсуждение исходный текст
Ответы Re: Durability?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

I got an error like this:

ERROR:  xlog flush request 1/C121E998 is not satisfied --- flushed only to 1/BCBCB440
CONTEXT:  writing block 529 of relation 1663/233690/1247
WARNING:  could not write block 529 of 1663/233690/1247
DETAIL:  Multiple failures --- write error might be permanent.

The xrecoff value (logs show 1/xrecoff) advances a few times during the day, but the message keeps appearing.

I am not sure to understand clearly the consequences of such error since Postgres continues to accept new transactions.
Ifmy WAL is corrupted, are my transactions still durable?
 
If this is a violation of durability, is there a way to force Postgres to terminate on such error?

Thanks in advance for the clarification.
Emmanuel




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

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: Review: Revise parallel pg_restore's scheduling heuristic
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Review: Revise parallel pg_restore's scheduling heuristic