| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2011-04-15 01:23:01 | Re: Version String |
| Previous Message | Jerry Sievers | 2011-04-14 23:23:49 | Re: Version String |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2011-04-14 23:50:44 | Re: Compression |
| Previous Message | Perry Smith | 2011-04-14 23:28:56 | Normalize or not? |