Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Streaming Replication limitations

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Simon Riggs <simon(at)2ndQuadrant(dot)com>, Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>, raghu ram <raghuchennuru(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] Streaming Replication limitations
Date: 2011-04-14 23:30:46
Message-ID: 1302823846.7584.2.camel@jdavis-ux.asterdata.local (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
On Wed, 2011-04-13 at 14:42 -0400, Tom Lane wrote:
> Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> > 2011/4/13 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> >> Short answer is to test the case you have in mind and see.
> 
> > That's the long answer, not least because the absence of a failure in
> > a test is not conclusive proof that it won't fail at some point in the
> > future while in production.
> 
> Not really.  Every known source of incompatibility (endianness,
> alignment, float format, etc) is checked at postmaster startup via
> entries in pg_control.

I seem to remember that Mac and Linux have a different notion of what
en_US collation means (I couldn't find any standard anywhere to say that
one was right and the other was wrong). So, that risks index corruption.

Regards,
	Jeff Davis


In response to

pgsql-admin by date

Next:From: Greg Sabino MullaneDate: 2011-04-15 01:23:01
Subject: Re: Version String
Previous:From: Jerry SieversDate: 2011-04-14 23:23:49
Subject: Re: Version String

pgsql-general by date

Next:From: Craig RingerDate: 2011-04-14 23:50:44
Subject: Re: Compression
Previous:From: Perry SmithDate: 2011-04-14 23:28:56
Subject: Normalize or not?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group