Re: Re: xReader, double-effort (was: Temporary tables under hot standby) - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Re: xReader, double-effort (was: Temporary tables under hot standby)
Date
Msg-id 4FA2D6E9.9080200@agliodbs.com
Whole thread Raw
In response to Re: Re: xReader, double-effort (was: Temporary tables under hot standby)  (Jim Nasby <jim@nasby.net>)
Responses Re: Re: xReader, double-effort (was: Temporary tables under hot standby)
List 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 by date:

Previous
From: Josh Berkus
Date:
Subject: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap
Next
From: Josh Berkus
Date:
Subject: Re: Temporary tables under hot standby