Re: Re: xReader, double-effort (was: Temporary tables under hot standby)

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Re: xReader, double-effort (was: Temporary tables under hot standby)
Дата
Msg-id 4FA2D6E9.9080200@agliodbs.com
обсуждение исходный текст
Ответ на Re: Re: xReader, double-effort (was: Temporary tables under hot standby)  (Jim Nasby <jim@nasby.net>)
Ответы Re: Re: xReader, double-effort (was: Temporary tables under hot standby)  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
> One thing I wanted to mention is that non-binary replication has an
> added advantage over binary from a DR standpoint: if corruption occurs
> on a master it is more likely to make it into your replicas thanks to
> full page writes. You might want to consider that depending on how
> sensitive your data is.

Yeah, we've seen this a few times.  We just recently had to rescue a
client from HS-wide corruption using Slony.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Temporary tables under hot standby