Cool thanks guys, I haven't had a chance to look at the database 
structure yet, so hopefully the geometry columns aren't the primary keys.

- Brian F

On 01/28/2012 08:48 PM, Steve Singer wrote:
> 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.
>
>
>>
>>
>>