[postgis-users] Replication question, can I replicate a postgres/postgis 9.0/1.5 instance to a 9.1/2.0 instance?

[Andreas Neumann]

Hi,

This depends on your chosen replication technology. With the builtin
streaming/cascading/synchronous replication you need exactly the same
versions for master and all the slaves. This is also an everything or
nothing replication. These builtin replication uses the WAL file to
replicate.

But with other technologies (e.g. Bucardo (which is trigger based)) you
can use different PostgreSQL versions. There is also pgPool, which is
statement based replication.

See also
http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling#Replication
for alternative, not builtin, replication.

Andreas

Am 09.01.2013 19:49, schrieb Basques, Bob (CI-StPaul):
> Subject says it all.  Possible ?
> 
> Thanks
> 
> Bobb
> 
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>