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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: xReader, double-effort (was: Temporary tables under hot standby)
Date: 2012-05-03 19:05:13
Message-ID: 4FA2D6E9.9080200@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2012-05-03 19:06:30 Re: Temporary tables under hot standby
Previous Message Josh Berkus 2012-05-03 18:52:18 Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap