On 02/26/2014 01:39 PM, CS DBA wrote:
> HI All;
>
> We have a client running postGIS, we're preparing to deploy SLONY.
> However the postGIS meta tables geometry_columns and spatial_ref_sys do
> not seem to get deployed with primary keys (via the postGIS install &
> enabling a db to be spatial).
>
> Anyone running replication across postGIS enabled databases?  Do we need
> to add primary keys and replicate the above gis meta tables? Or are
> these simply lookup / meta data that will be populated appropriately as
> stand alone tables on both the master and the slave?
>


In addition to what other people have said on the primary keys, you 
should be aware of 
http://lists.slony.info/pipermail/slony1-general/2012-March/012138.html

In any of the postgis stuff I've done I never update a geometry column 
in a way so the before/after is spatially equal but some people might.



>
> Thanks in advance...
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>