Re: Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1

On 2013-11-19 10:16:26 -0800, Josh Berkus wrote:
> On 11/19/2013 09:58 AM, Andres Freund wrote:
> > On 2013-11-19 09:51:28 -0800, Josh Berkus wrote:
> >> Maybe it's worth it now to devise some automated replication testing?
> >
> > It'd be a good idea, but I am not sure where to get resources for it
> > from.
>
> Well, servers isn't hard ... various cloud companies will donate them.

Yea, I was talking about human/time/financial ones.

> What would be hard is writing the tests. I know how they should work,
> and the tools to use, but there's about 1,000 to 2,000 lines of code
> between here and there.

I am not sure how much code it's going to take (I'd hope somewhat less),
but it certainly will take some time to agree how it should be built and
then building and integrating it.

> (This is why we should have encouraged the folks from SFDC and Huawei
> who wanted to do testing, instead of blowing them off.)

Haven't noticed/followed anything around that.

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services