[prev in list] [next in list] [prev in thread] [next in thread] 

List:       slony1-general
Subject:    Re: [Slony1-general] slony and postgis?
From:       Brian Fehrle <brianf () consistentstate ! com>
Date:       2012-01-30 17:24:15
Message-ID: 4F26D23F.8010209 () consistentstate ! com
[Download RAW message or body]

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.
>
>
>>
>>
>>

_______________________________________________
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
[prev in list] [next in list] [prev in thread] [next in thread]