Postgres Pro
Downloads
Home   >   mailing lists

Re: Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1 - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1
Date
Msg-id 528D0409.8080803@agliodbs.com
Whole thread Raw
In response to Re: Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On 11/20/2013 10:30 AM, Josh Berkus wrote:
> Andrews, Kevin:

Andres, that is.

> 
> Presumably a replica created while all traffic was halted on the master
> would be clean, correct?  This bug can only be triggered if there's
> heavy write load on the master, right?
> 

Also, just to verify:

If someone is doing PITR based on a snapshot taken with pg_basebackup,
that will only trip this corruption bug if the user has hot_standby=on
in their config *while restoring*?  Or is it critical if they have
hot_standby=on while backing up?

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

pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: nested hstore patch
Next
From: Andrew Dunstan
Date:
Subject: Re: additional json functionality