Steve Singer steve at ssinger.info
Sat Jan 28 19:48:53 PST 2012
On Sat, 28 Jan 2012, Christopher Browne wrote:

> 
> As long as the data types serialize in a reasonable form, and survive
> pg_dump, they should replicate fine.
> 
> Needs to be stable to use it in a primary key.  E.g. , date stamp values may
> reload as a slightly different value due to rounding. If GIS values do the
> same, they may make poor primary keys.  Slony might expose edges you
> mightn't see elsewhere.

I sometimes setup replication clusters of GIS data when testing slony and 
have never had a problems, I can't even recall any edge cases that it 
exposed.

Making a postgis geometry column part of a primary key is a bad idea/design 
even if you aren't using slony.


> 
> 
>


More information about the Slony1-general mailing list